+ Reply to Thread
Results 1 to 5 of 5

Figuring out Overtime Formula

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

    Figuring out Overtime Formula

    [Deleted] Please Close.
    Attached Files Attached Files
    Last edited by tommygoesha; 02-08-2016 at 02:08 PM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Figuring out Overtime Formula

    Something like =max(0,total_weekly_hours -40/24) to calculate overtime (time expressed in sexagesimal notation)

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

    Re: Figuring out Overtime Formula

    not really sure how to use that ._.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Figuring out Overtime Formula

    Sorry by "total_weekly_hours" I meant the cell reference containing the total of worked hours in a week ( like D9)

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

    Re: Figuring out Overtime Formula

    That doesn't seem to do what i think its suppose to. Do i put it in k9? and put i9 for total weekly hours?

+ 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. Replies: 3
    Last Post: 01-21-2016, 06:07 PM
  2. Need help figuring out a formula
    By tejasjeorge in forum Excel General
    Replies: 2
    Last Post: 07-01-2015, 10:22 AM
  3. How do you calculate Square Foot in a formula
    By icevinson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-16-2014, 02:58 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. Need help with figuring out a formula please
    By DavidJ726 in forum Excel General
    Replies: 5
    Last Post: 05-29-2006, 11:25 PM
  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