site Search:


 
    All Forums Hot Topics Gallery






how-to block ads


 
Search Topic:
Share Topic
Posting?
Post a:
Post a:
Links: ·MS Apps FAQ ·Windows XP FAQ ·Windows 7 FAQ ·Windows Home ·Office Home
AuthorAll Replies


brianmcd
Premium
join:2000-09-06
Norristown, PA

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.

Monday, 13-Feb 12:07:34 Terms of Use & Privacy | feedback | contact | Hosting by nac.net - DSL,Hosting & Co-lo
over 12.5 years online! © 1999-2012 dslreports.com.
Most commented news this week
Hot Topics