E
Erica
I am putting together a spreadsheet that calculates the hours worked in
military time basesd on the clock in/out time, however the formula I am using
will not calculate the hours worked for an overnight associate. I.e. clocks
in @ 9:00 PM and clocks out at 7:00 AM
The formula I am using is as follows:
=IF(((C9-B9)*24)>=5,C9-(B9+TIME(0,30,0)),C9-B9)*24
Thank you!!
military time basesd on the clock in/out time, however the formula I am using
will not calculate the hours worked for an overnight associate. I.e. clocks
in @ 9:00 PM and clocks out at 7:00 AM
The formula I am using is as follows:
=IF(((C9-B9)*24)>=5,C9-(B9+TIME(0,30,0)),C9-B9)*24
Thank you!!