+ Reply to Thread
Results 1 to 4 of 4

Overtime chart & formula

  1. #1
    Registered User
    Join Date
    12-23-2015
    Location
    California
    MS-Off Ver
    2010
    Posts
    24

    Overtime chart & formula

    So what i am trying to do is after 40 hours of straight time (not counting overtime). It should make every hour after that overtime. So if you work 9hrs a day mon-fri that would only be 40 straight hours that way on Saturday its all overtime.
    Is there a formula or how can i set it up without moving too much? (also is there a way to set up the date to automatically change depending on what month it is? Thanks! Overtime.xlsx

  2. #2
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: Overtime chart & formula

    Is your standard day 8 hours?

  3. #3
    Registered User
    Join Date
    12-23-2015
    Location
    California
    MS-Off Ver
    2010
    Posts
    24

    Re: Overtime chart & formula

    standard day is 9 hours with 1 hour of overtime after 8.

  4. #4
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: Overtime chart & formula

    Hi,

    The easiest way is to add in a normal hours column with a formula like this...

    Please Login or Register  to view this content.
    Copy of Overtime.xlsx

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Figuring out Overtime Formula
    By tommygoesha in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 02-08-2016, 01:44 PM
  2. Replies: 3
    Last Post: 01-21-2016, 06:07 PM
  3. Need help figuring out a formula
    By tejasjeorge in forum Excel General
    Replies: 2
    Last Post: 07-01-2015, 10:22 AM
  4. Need help figuring out a formula
    By Corporate Bob in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-09-2013, 03:03 AM
  5. Figuring out the appropriate formula with IFS
    By Vallheos in forum Excel General
    Replies: 4
    Last Post: 09-02-2011, 01:31 AM
  6. Figuring Out A formula to...
    By ken in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-06-2005, 09:05 PM
  7. Figuring Overtime In Spreadsheet
    By bEN AKINS in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-27-2005, 01:53 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