Thanks Rejesh. I have added an extra tab (sample) to show the sheet with different entries. On the "Your recall Track" tab I have three lines. The top row shows the overtime hour incorrectly in Column S. This should have been a 1:00 and nothing in column T, it can n...
I need a formula that will accomplish the following, and I am not sure how to create it. We have employees who have 2 different rates, one for Work and one for Drive. Our payroll spreadsheet has ea... I applied the changed code to my google sheet document and with a...
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)...
Looking at it, it has to do with how excel and docs seem to handle empty cells. in the overtime calculation excel is putting a 0 in cells and docs is not. That means that other parts of the formula that were checking if the cell is empty or not weren't working. I've added a b...
Thanks to , I now have my regular, O.T. and D.T. auto populating.My new problem is that in another cell, I try to calculate the hours worked by the hourly...
Excel Your community for how-to discussions and sharing best practices on Microsoft Excel. If you’re looking for technical support, please visitMicrosoft Support Community. Forum Discussion
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) BrianN68, you are welcome. So, it works now and there are no open questions? SergeiBaklan Yes, it is working good now. ...
BrianN68, you are welcome. So, it works now and there are no open questions? 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),...