+ Reply to Thread
Results 1 to 1 of 1

Time sheet Problems

  1. #1
    Registered User
    Join Date
    Murrieta, California
    MS-Off Ver
    Excel 2003

    Time sheet Problems

    I am trying to create a hours worked calculator for my company. I've got a start on it but I have come upon some problems. I need to be able to track total numbers of hour worked per day, standard hours(hours up to 8 in one day) overtime hours (hours after 8 worked in one day up to 12 and any hours after 40 in a week) and double time hours (any hours after 12 in one day).
    Another issue I am having is when I have people work jobs that span 2 days, starting at 10 pm Monday and ending at 2 am Tuesday, I need to track those hours to the day worked. So that person would get paid 2 hours on Monday and 2 hours on Tuesday and they still have to fall into the correct category, standard overtime or double time.....CONFUSING I know. I have attached what i have started, any help would be greatly appreciated.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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