+ Reply to Thread
Results 1 to 3 of 3

Hours Breakdown to Normal Time, T5 & DT

  1. #1
    Registered User
    Join Date
    08-29-2012
    Location
    Queensland, Australia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Hours Breakdown to Normal Time, T5 & DT

    Hi,

    Sorry this is probably an easy one but having alittle trouble working it out.

    I have daily hours that I need to break down to normal time, time & half and Double time.

    Normal Time = upto 8 hours
    Time & Half = upto 2 hours after first inital 8hrs
    Double Time = anything over 10hrs for day

    Date Hrs NT T5 DT
    5/9/12 11.50 8 2 1.50
    5/9/12 7.50 7.5
    6/9/12 9.00 8 1
    6/9/12 10.00
    6/9/12 12.00
    6/9/12 12.00
    8/9/12 10.00
    8/9/12 10.00

    Cheers,
    Ral

  2. #2
    Registered User
    Join Date
    08-29-2012
    Location
    Queensland, Australia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Hours Breakdown to Normal Time, T5 & DT

    Sorry just realised that I need to break it down based on a day as well.

    The able listed breakdown is for Monday to Friday work.

    if they work on a saturday it is:
    Time & Half = First 2 hours
    Double Time = anything after the first 2 hrs

    Working sunday is all Double Time

  3. #3
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Hours Breakdown to Normal Time, T5 & DT

    Hi Rallie1982

    Is this something that you could work with! The sheet is for decimal time, not normal time.
    Attached Files Attached Files
    Last edited by Kevin UK; 10-09-2012 at 04:43 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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