tao
Chaos Impends
Premium
join:2000-12-03
Lansing, MI
 ·Comcast
| reply to neonhomer
Re: [Excel] Figuring overtime and assign a value
To simply this, you should use military time. So one day of work becomes 700 to 1600, or 9 hours. Then the OT equals the number of hours worked minus 8.
If you must have the presentation you show, then do your calculations on a second sheet and link the values.
Further, I see a bug there in the hours, if this is signed and all that, the hours total maybe should not be 43 hours. As you see at the top, the total hours is now 46, I corrected this in the linked file.
Anyway, my 2 cents...
--
I play darts: »www.triple20dartingsupplies.com | »www.adaoflansing.com
I support unions: »www.1099alldrivers.org www.1039atu.com
|
tao
Chaos Impends
Premium
join:2000-12-03
Lansing, MI
·Comcast
| Played with that sheet a bit more and got the zones working with a compromise. The cells for the zones were split into two columns, with the right being for zone 4 and the left for zone 3, then the cells having numerical values was counted and a function was added to the top list to handle those numbers.
But like I wrote in the previous post, if you need the sheet to have all the features you showed in your example, then simply place the calculations on sheet B and link them to A.
--
I play darts: »www.triple20dartingsupplies.com | »www.adaoflansing.com
I support unions: »www.1099alldrivers.org www.1039atu.com
|
