Times crossing into midnight for difference or duration

raffrobb

New member
Joined
Jun 3, 2019
Messages
2
Reaction score
0
Points
0
Excel Version(s)
365
Hi All

How do I get the correct time difference when times cross over midnight?
Do I need to include day and time, or can I just do times.

is best format 3/2/20 11:45:28 PM minus 3/3/20 12:03:31 AM?

11:45:28 PM12:03:31 AM

Thanks
Robb
 

Attachments

  • PQ TIMES.xlsx
    9.9 KB · Views: 9
I've attached a sample that should get you there although... are you sure your original Excel times are right? One of those records (I've highlighted in yellow) actually crosses 2 days.
 

Attachments

  • PQ TIMES.xlsx
    20.3 KB · Views: 21
Back
Top