Results 1 to 2 of 2

Calculating overtime

Threaded View

  1. #1
    Registered User
    Join Date
    11-04-2014
    Location
    New York
    MS-Off Ver
    2013
    Posts
    1

    Calculating overtime

    I am trying to create a timesheet that gives overtime daily over 8 hours and also over 40 hours per week. What kind of formula can I use for this?

    Monday - 0 hours
    Tuesday - 13.25 (8 Reg, 5.25 OT)
    Wednesday - 12.5 hours (9.25 Reg, 3.25 OT)
    Thursday - 20.25 hours (8 Reg, 12.25 OT)
    Friday - 2.25 hours (2.25 Reg)
    Saturday - 13.5 hours (8 Reg, 5.5 OT)
    Sunday - 10 hours (4.5 Reg, 5.5 OT)
    I have this formula for the weekly, but I need one for the daily:
    =IF(G19>40, 40,G19)

    Thank you!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculating daily overtime and weekly overtime
    By Guy Montague in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-22-2016, 04:55 PM
  2. Calculating Overtime
    By Dale Nixon in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-18-2008, 08:31 PM
  3. Calculating overtime....
    By cyberdemon in forum Excel General
    Replies: 3
    Last Post: 08-07-2007, 12:16 AM
  4. Calculating Overtime
    By sam13484 via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-03-2006, 11:25 AM
  5. Calculating overtime
    By jennerifw in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 08-09-2005, 03: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