+ Reply to Thread
Results 1 to 3 of 3

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; Yesterday at 06:17 PM.

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

    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

+ 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