Poll: Need to make sure ordinary and overtime is separate

+ Reply to Thread
Results 1 to 5 of 5

Hours worked on Different Shifts - Breakdown on overtime and ordinary

  1. #1
    Registered User
    Join Date
    07-22-2015
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    4

    Talking Hours worked on Different Shifts - Breakdown on overtime and ordinary

    Hi There

    I need your help. in a desperate situation and I am really worried I cant do this on my own. Pleas help...

    Ordinary hours = 6am - 6pm
    O/Time Hours = 6Pm - 6 am

    O/Time hours are calculated, first 2 hours is paid at a different rate so needs to move separately to a 1.5 column and the rest moves into 2 column.

    So as below, my table will look like this;
    A B C D E F G
    1 Name Start Finish Ordinary O/T 1.5 O/T 2 Total hrs
    2 Bradd Clabby 9:00am 6:00pm 8 1 0 9
    3 Bradd Clabby 6:00am 8:00pm 8 2 4 14
    4 Bradd Clabby 4:00pm 5:00am 2 2 9 13


    As you see from the table above, I need formulas which will work out the ordinary, O/T 1.5 and O/T 2 by only putting in information to start and finish time

    Basically, need the formula for Cell D2, Cell E2, Cell F2, Cell G2. I have use If or vlookup formulas and failed when someone works between day and night shift. Do you think you can help?

  2. #2
    Registered User
    Join Date
    07-22-2015
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    4

    Re: Hours worked on Different Shifts - Breakdown on overtime and ordinary

    I think my table looks weird so I am posting it again. Thanks
    A B C D E F G
    1 Name Start Finish Ordinary O/T 1.5 O/T 2 Total hrs
    2 Bradd Clabby 9:00am 6:00pm 8 1 0 9
    3 Bradd Clabby 6:00am 8:00pm 8 2 4 14
    4 Bradd Clabby 4:00pm 5:00am 2 2 9 13

  3. #3
    Registered User
    Join Date
    07-22-2015
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    4

    Re: Hours worked on Different Shifts - Breakdown on overtime and ordinary

    Seriously ? Not working

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,504

    Re: Hours worked on Different Shifts - Breakdown on overtime and ordinary

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    07-22-2015
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    4

    Re: Hours worked on Different Shifts - Breakdown on overtime and ordinary

    Attached the table. please help
    Attached Files Attached Files

+ 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. Calculating Overtime (after 40 hours worked)
    By YolandaJ55 in forum Excel General
    Replies: 4
    Last Post: 04-05-2015, 04:59 PM
  2. Replies: 2
    Last Post: 01-17-2014, 02:22 PM
  3. [SOLVED] Breakdown of total daily worked hours
    By beitzy in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 02-05-2013, 10:11 PM
  4. Replies: 1
    Last Post: 10-06-2012, 06:45 AM
  5. Timesheet formula for calculating ordinary hours and overtime hours.
    By zoen in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-18-2011, 04:23 AM
  6. Calculating total overtime hours worked per employee
    By markjmcl in forum Excel General
    Replies: 3
    Last Post: 09-07-2011, 06:49 PM
  7. Replies: 0
    Last Post: 08-23-2005, 12:36 PM
  8. A function that separates hours worked in work shifts that overlap
    By Katybug1964 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2005, 05:06 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