Results 1 to 5 of 5

Trying to create a time sheet to calculate my regular time/ overtime

Threaded View

  1. #1
    Registered User
    Join Date
    09-12-2012
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2007
    Posts
    5

    Trying to create a time sheet to calculate my regular time/ overtime

    I am trying to create a spread sheet that will allow me to key in when I started and stopped work. But there are certain guidelines to incorporate. Anything over 10 hours in a single shift is Overtime. So for example if I work from 5:00 am to 5:00 pm that would be 10 hours regular time and 2 hours overtime. Once I hit 44 hours of regular time in a week though everything is then over time. I had a couple of members on another forum try and help me with this and although they got very close it is still missing certain calculations. At first glance it seems like it works great until you change one of the first shifts to 0 hours worked than the formula is off.

    Any assistance would be greatly appreciated. I will attach what I have so far.


    This is a cross post from another site:
    http://www.excelguru.ca/forums/showt...g-overtime-etc
    Attached Files Attached Files
    Last edited by Chichirod; 04-02-2015 at 09:19 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculating Regular Time, Overtime, Double Time
    By SoCalRizzy in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 06-29-2023, 11:54 PM
  2. [SOLVED] Help with determining the number of regular vs. overtime hours within a set time frame
    By niftysquirrel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-05-2013, 12:52 PM
  3. Replies: 5
    Last Post: 04-18-2013, 11:31 AM
  4. Overtime and Regular Time sheet formula setup
    By mmedina in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-04-2010, 02:46 PM
  5. Timesheet Regular Time and Overtime w/Account Codes
    By karstens in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-01-2006, 12:33 PM

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