Thread: Difference between times. Start time: 11:30PM End time: 5 AM
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Difference between times. Start time: 11:30PM End time: 5 AM
Try this,

Works for times over midnight and times on the same day

=(B1-A1+(B1<A1))*24

Mike

"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!
Reply With QuoteReply With Quote