Excel Time Duration Formula

[RudeRam]

I am using the following formula to get a time duration, however it wil
not work wihen time starts before midnight and ends after midnight.
need to keep the results the same i.e. Duration is 1.8

=IF(OR(A1="",B1=""),"",HOUR(B1-A1)+MINUTE(B1-A1)/60)

Thanks for any hel

 

[Frank Kabel]

Hi
try
=IF(OR(A1="",B1=""),"",(B1-A1+(B1<A1))*24)

 

[JE McGimpsey]

One way:

=IF(COUNT(A1:B1)<2,"",HOUR(MOD(B1-A1,1))+MINUTE(MOD(B1-A1,1)))

 

[RudeRam]

Frank Thank you , your formula was what I was looking for.
:cool