HOURS CALCULATION

S

Stuart Carnachan

Would like to calculate no of hours in a specied shift. I can do this until
foe example start time is 22:00 and end time is 04:00 next day - Can somebody
help ?
 
L

Lori

If A1 is start time and B1 is end time:

=MOD(B1-A1,1)

(make sure the result in time format.)
 
Top