Results 1 to 12 of 12

Over time formula needed

Threaded View

  1. #1
    Registered User
    Join Date
    01-26-2015
    Location
    Canada
    MS-Off Ver
    Office Professional Plus 2010
    Posts
    16

    Over time formula needed

    Hi,
    I have been trying to figure out a formula for over time. The way our over time works is this:

    If you work 2 hours or less you get paid 3 hours of straight time over time (STO)

    If you work 2 hours or more you get paid the first 2 hours at 1 1/2 (1.5X) times (THO) and the rest at 2X (DTO).

    For example,
    I work 1.5 hours = 3 hours at STO
    I work 4 hours = 2 hours at THO and 2 hours at DTO.

    I would like to develop a Time Sheet where I can enter my total time worked and the sheet will calulate what hours are put into the 3 columns above.

    Over Time Explanation Hours Wrkd STO THO DTO
    Completing contract 1 1.5 3
    Completing contract 2 4.0 2 2
    Completing contract 3 7.0 2 5

    Totals 3 4 7



    Any help would be appreciated.

    Russ
    Last edited by Russ15; 01-26-2015 at 04:32 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Military Time Formula Needed
    By BubbasExcel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-01-2013, 11:14 PM
  2. Excel 2007 : Time formula needed
    By nanlag in forum Excel General
    Replies: 4
    Last Post: 04-27-2012, 04:56 PM
  3. [SOLVED] Excel formula help needed On time Delivery
    By Molson_Canadian in forum Excel General
    Replies: 2
    Last Post: 01-16-2012, 09:02 PM
  4. working time and over time formula needed please
    By Crasher in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 10-09-2006, 08:48 PM
  5. [SOLVED] Formula Needed for Transit Time
    By Angela in forum Excel General
    Replies: 1
    Last Post: 08-09-2005, 04:05 PM

Tags for this Thread

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