calculating work hours
Posted by Jayne on February 05, 2002 1:37 PM
I have an hour calcualtor. Very simply done. I need a formula to add up am-pm hours. For example, I have in my sheet where I clock in at 4 pm Monday, clocked out 8 pm Monday, clocked back in 9 pm and clock out to go home at 1 am. I need to get this to add up to 8 hours since that's what I actually worked.
Posted by Steve Hartman on February 05, 2002 2:02 PM
Assuming the times are:
A1 Clock in
B1 Clock out
C1 Clock Back in
D1 Go Home
=((D1-C1+(D1<C1))-(C1-B1+(C1<B1)))*24
should do it
Posted by Steve Hartman on February 05, 2002 2:06 PM
Assuming the times are:
A1 Clock in
B1 Clock out
C1 Clock Back in
D1 Go Home
=((D1-C1+(D1< C1))-(C1-B1+(C1< B1)))*24
should do it. Omit the spaces after the < signs.
Posted by Steve Hartman on February 05, 2002 2:09 PM
Should be =((D1-A1+(D1< A1))-(C1-B1+(C1< B1)))*24
