24 hr Time Calculation

[edgar]

I am trying to calculate the difference between 2 times
in excel, the formula works fine until 1 of the times is
after 00:00 the formula then returns the #### error as
the time is negative.

Does anyone know how to fix this?

TIA

Edgar

 

[Ron de Bruin]

Try this

=(B1-A1+(B1<A1))*24