Work hours calculation
Assuming A1,B1 are in hh:mm format:
=MOD(B1-A1,1)
"albertmb" wrote:
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
|