I am using this formula to show OT hours worked based off N21 being the total hours for the day. It needs to use the DUR2HOURS or it doesn't work properly.
=MAX(DUR2HOURS(N21)-8, 0)
I have another cell to calculate double over time, which is anything after 12 hours.
How can I adjust the above formula to show the OT hours but not the DOT hours?
Thanks in advance for any help!!!
MacBook
PW,
I would normally not like to perpetuate a double post, but I think I can be concise here.
Here's what I think would cover all three cases; Standard Pat, Overtime and Double overtime.
The expressions are:
Standard Pay...
=DUR2HOURS(MIN(A, "8h"))
OverTime...
=DUR2HOURS(MIN(MAX("0h", A−"8h"), "4h"))
Double OverTime...
=DUR2HOURS(MAX("0h", A−"12h"))
Jerry
For the specific case of the duration in N21, the above expressions would be:
Standard Pay...
=DUR2HOURS(MIN(N21, "8h"))
OverTime...
=DUR2HOURS(MIN(MAX("0h", N21−"8h"), "4h"))
Double OverTime...
=DUR2HOURS(MAX("0h", N21−"12h"))
Jerry
Need help adjusting formula on time sheet
