Times crossing into midnight for difference or duration

[raffrobb]

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 PM

12:03:31 AM

Thanks
Robb

 

[Ken Puls]

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.