Forum Discussion
Solved
Calculating overtime and double time
Good day. I am struggling with a part of my personal time sheet, and hope that some one can help me out with it. I am using the office suite that is accessible to me on my hotmail account. Time ...
It could be
C2: =MOD(B2-A2,1) E2: =IF(C2 > D2, MIN( C2 - D2, 3/24), 0 ) F2: =IF( C2 > (D2 + 3/24), C2 - D2 - 3/24, 0 )
I have a question....
I already have a sheet with different fields and my OT column is working, but I need a formula for DT.
Anything over 4 hrs in the G column (OT) needs to go to H column (DT), but G column needs to stay at 4
Start Finish Total Job Description Reg OT DT
8:00 AM 9:45 PM 13.75 At office. 8 4 1.75
C: =(MOD(C12-B12,1)*24)
E: =(D12)-G12
F: =IF((MOD(C12-B12,1)*24)>8,(MOD(C12-B12,1)*24)-8,0)
G: what should this be...?Or what should I change all my formulas to?
