Results 1 to 4 of 4

Calculating straight time and overtime

Threaded View

  1. #1
    Registered User
    Join Date
    11-14-2008
    Location
    Alaska
    Posts
    7

    Calculating straight time and overtime

    I'm pretty new at the whole Excel thing and many of the formulas are way over my head.
    I'm trying to figure out how to make a time sheet calculate straight time and overtime and I can not figure it out. The time sheet from the Excel Bible was close, but not quite what I'm looking for.

    I work seven rotating twelve hour shifts and anything over eight hours and anything over twelve hours is overtime. The shifts start at 0600 and 1800.

    I have several questions.
    1. how do I get the times to calculate? It works correctly when doing one shift (days), but not the other (night). It adds up to 24 on night shift.
    2. how do I make it seperate the twelve hours into 8 straight time hours and four over time hours?
    3. how do I get it to know when it has reached the 40 hour mark?
    Attached Files Attached Files
    Last edited by TMA; 11-14-2008 at 09:58 AM.

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