Thread: Difference between times. Start time: 11:30PM End time: 5 AM
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
  
Posts: 1,104
Default Difference between times. Start time: 11:30PM End time: 5 AM
=(B1-A1) will work unless you pass through midnight
=(B1-A1)+(B1<A1) will correctly add 1 (one day, that is, 24 hours) when B1
appears to be before A1 (ie you passed through midnight)
Try it with some of your data and tell me if you are happy with it
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Surrey" wrote in message
...
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!


Reply With QuoteReply With Quote