Results 1 to 5 of 5

Counting overtime with a twist

Threaded View

  1. #1
    Registered User
    Join Date
    02-04-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    19

    Counting overtime with a twist

    Okay so the basics:

    Each employee has a different plan time each day of the week.
    Mon - 9 Tues - 9 Wed - 7 Thur - 8 Fr - 7

    Overtime is really counted after 40

    There are 5 sheets for each day of the week mon-fri lets say sheet1..2...3...etc, on each sheet there is a column a with plan and column b with actual hrs.

    What I'm looking for is a summary sheet for each employee to see where they trend in OT after each day so...

    person1 works 10 hrs on mon with a 9 hour plan thus 1 hr trending OT. On the summary page person1 would now show 1 hrs of OT. Now if they would work 9 hrs on tues it would still show 1 hr of OT. On wed however they worked 6 hrs so now the summary page would 0.

    Hope this makes sense...thanks for the help.
    Last edited by polska21800; 02-05-2010 at 03:17 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1