hour count after midnight

[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

 

[Bill Kuunders]

deducting F column from E column

=24*(IF(F16>E16,E16+1-F16,E16-F16))

 

[Harald Staff]

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

HTH. Best wishes Harald

 

[nicolas.schimpf]

Thanks you it works
Perfect