Work hours calculation

[Guest]

Hi everyone,
I have a problem with calculating work hours. I use the normal simple
formula Ex:
=(B1-A1)*24 Assuming that 'A1' is the in time and 'B1' is the out time.
This works OK, but if the in time is before midnight and the out time is
after midnight it does not work. I managed to get the answer right by adding
24 to the formula but then it will not work properly for time before midnight.
I appreciate your help and thank you.

Albert - Malta

 

[Guest]

Assuming A1,B1 are in hh:mm format:

=MOD(B1-A1,1)

 

[Guest]

Either use Toopers' suggestion and multiply by 24, i.e.

=MOD(B1-A1,1)*24

or

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

 

[Guest]

Thank you Toppers and Daddylonglegs, formula worked perfectly.

All the Best
Albert