I need an Excel 2003 agrument that will return a positive number for the time in hours:minutes between midnight and 8pm of the previous day.
Start Date Begin Time End time(midnight) 06/01/07 20:00:00 0:00:00