brianmcd
join:2000-09-06
Norristown, PA
clubs:
 ·Verizon FIOS
| reply to neonhomer
Re: [Excel] Figuring overtime and assign a value
I used to calculate OT by using a Column with the Total Daily Hours and a Hidden Column with a Running Total Hours for the week.
On a daily basis I set up some calculations to test the following to determine Regular Hours:
If running total is 40 then regular hours are zero.
else
regular Hours are 40 - ( Running Total - Daily Total)
I then used Daily Total - Regular Hours to calculate OT Hours
You can use another hidden column to place the appropriate value for you driving and sum this column. Then reference this for your Zone Column.
All of these calculations make use of Nested Immediate IF statements in excel. |
