Help needed with calculating times

Hello all, I hope there are answers out there!

I am currently working with UTC times in an excel document, I am trying to add up hours where someone works but use UTC times.

(for example, Bob works from 1900 to 0500).

I am trying to determine the best way to calculate the hours up to determine how many hours are between 1900 and 0500 together.

I hope this is clear enough to understand, thank you you for your help in advance!

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

Try:

Formula:

Please Login or Register  to view this content.