+ Reply to Thread
Results 1 to 4 of 4

Adding hours worked after a specific shift start time?

  1. #1
    Registered User
    Join Date
    03-25-2020
    Location
    Brisbane, Australia
    MS-Off Ver
    365 Proplus, excel1902
    Posts
    4

    Adding hours worked after a specific shift start time?

    Hi Everyone

    Absolute newb at Excel but im giving it a crack. I am trying to improve my work roster by adding in coloums to calculate costs for each employee.

    Where im struggling is the adding up hours worked on different days when start times change, as after 10am a allowance is paid.

    If a shift starts "after"10:00hrs it attracts a 15% allowance. Column ER

    If a shift has any hours worked between 22:00hrs to 06:00hrs it attracts a further 5% allowance.Column ES

    Chasing assistance on adding hours worked on a particular days where the start time commences after 10:00hrs and counting any hours that are worked between 22:00hrs and 06:00hrs, during a night shift.

    Not sure what to do with OT hours as we work compressed hours being 8 x 8.5hr days, 1 x 8hrs day with an RDO which makes up our 76hrs for the fortnight.

    I currently am working on Row 5 with the formulas.

    Any suggestions or help would be greatly appreciated.

    Kind regards
    Geoff0001
    Attached Files Attached Files
    Last edited by Geoff0001; 03-27-2020 at 06:17 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    04-26-2015
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    500

    Re: Adding hours worked after a specific shift start time?

    I wouldn't even know where to start looking for an answer, that is one complex spreadsheet you have created. The attachment may have the answers you need or may be able to point you in the right direction.

    It's a sheet that contains formulas relating to shift work along with a few examples.
    Attached Files Attached Files
    Uploading an attachment will assist Forum Members in finding the correct Solution for you. Create a dummy worksheet if necessary, add your start data and show where / what your expected results should be. TO ADD A FILE:

    Go to 'Advanced. click on 'Manage Attachments. Select 'Browse & Choose your file, Select 'Upload and then close the Attachment window.

  3. #3
    Registered User
    Join Date
    03-25-2020
    Location
    Brisbane, Australia
    MS-Off Ver
    365 Proplus, excel1902
    Posts
    4

    Re: Adding hours worked after a specific shift start time?

    Thanks BlindAlley
    Appreciate the help, I will check it out and see how I go.
    Kind regards Geoff0001

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    11,881

    Re: Adding hours worked after a specific shift start time?

    It may help if you could tell us the number values that you would place in ER5:ES5 if you were doing this by hand. Please include an explanation of why those numbers would be placed there given the data in columns F:EK (I assume the information to be used is in row 5). If we know the expected numbers and why they are expected we may have a better chance of producing formulas/code that can replicate the numbers.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] Calculating multiple pay rates based on time of day worked, not number of hours worked
    By vdbonce in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-04-2020, 02:30 AM
  2. [SOLVED] Calculate hours worked within a time range
    By ilohyou in forum Excel General
    Replies: 5
    Last Post: 11-22-2017, 04:04 PM
  3. Replies: 0
    Last Post: 05-14-2012, 05:36 PM
  4. Calculating basic hours worked, between a time range, problems
    By RoyLittle0 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-07-2012, 05:40 PM
  5. Calculating basic hours worked, between a time range and premium hours worked
    By RoyLittle0 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-07-2012, 06:59 AM
  6. Replies: 0
    Last Post: 01-05-2012, 06:23 AM
  7. Counting hours worked in a range.
    By Pittman in forum Excel General
    Replies: 6
    Last Post: 06-09-2008, 06: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