hour count after midnight

N

nicolas.schimpf

Hi all,

Is there a way to calculate hour betwen eg.
23:00 and 01:00 after midnight.
it calculates correctly when I put 25:00 instead 01:00.

Is there another way???

Thanks for your help
 
H

Harald Staff

Start time in A1, end time in B1. Duration:
=B1-A1+(B1<A1)

HTH. Best wishes Harald
 
Top