View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Codeman Codeman is offline
external usenet poster
 
Posts: 27
Default Difference between times. Start time: 11:30PM End time: 5 AM

You could enter time similar to military time. 11.50 (11:30 am) start and
17.00 (5:00 pm) as end time. That is if you are familiar with decimal half
hours and quarter hours. But the other responses may already have the fix
for you.

"Surrey" wrote:

I need to calculate the difference between times. The tricky part is that the
start time is: 11:30PM and end time is: 5:00AM. Thanks for your help!