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 )
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 )
Edited: I think I have it. I just put 8/24 in place of the $K$55.
Works like a charm. Thank you for your time on this.
If I could though, ask one more question on this.
Is there a way on cell D2 to have it max at 8 hrs without having to refer to cell K55?
You are welcome.
I'm not sure what do you have in C55, L55, etc. As for D2, max of 8 and what ? Perhaps you may give bit more details.
- SergeiBaklan.
Sorry for the confusion on that. I thought that I changed it all to row 2.
The B55, C55 etc is where I had these cells in my spreadsheet.
For D2, that would be my straight time. To show 8 hours, the next 3 hours go to E2, then, anything over 11 hours goes to double time.
But, with your help, I have it working now.
Thank you.