+ Reply to Thread
Results 1 to 4 of 4

Calculation: Timesheet for group - overtime, double time and night shift allowance.

  1. #1
    Registered User
    Join Date
    01-27-2013
    Location
    Kuurman, South Africa
    MS-Off Ver
    Excel 2016 Professional
    Posts
    17

    Calculation: Timesheet for group - overtime, double time and night shift allowance.

    I am trying to do a Timesheet for a group of people in Excel 2016.
    South African law prescribe the calculation of overtime, double time and night shift allowance.
    Overtime = hours worked more than 9 hours per day.
    Double Time = work on Sundays or Public Holidays.
    Night Shift Allowance = hours of work between 18:00 and 6:00.
    Can somebody help with the formula to do the calculation per day.
    Attached is a sheet used to enter the data per day and this is then added to the database from where all reports and dashboards are done.
    Regards
    Attached Files Attached Files

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Calculation: Timesheet for group - overtime, double time and night shift allowance.

    there is no any time out for rows 65:73

  3. #3
    Registered User
    Join Date
    01-27-2013
    Location
    Kuurman, South Africa
    MS-Off Ver
    Excel 2016 Professional
    Posts
    17

    Re: Calculation: Timesheet for group - overtime, double time and night shift allowance.

    Please just delete them or ignore them.
    Thanks for looking at my request.

  4. #4
    Registered User
    Join Date
    01-27-2013
    Location
    Kuurman, South Africa
    MS-Off Ver
    Excel 2016 Professional
    Posts
    17

    Re: Calculation: Timesheet for group - overtime, double time and night shift allowance.

    I have changed the data in the attached file to include some night shift work.
    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. [SOLVED] Calculate hours during set times for night shift allowance
    By mbeire in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-14-2017, 09:32 PM
  2. Timesheet, overtime and double overtime calculation
    By breegunn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-10-2016, 07:17 PM
  3. [Solved] Night shift allowance (2200-0600) start and finnish time vary
    By grunternic in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-03-2015, 05:49 AM
  4. Timesheet with overtime and double time
    By ymqiao in forum Excel General
    Replies: 2
    Last Post: 06-26-2015, 02:17 AM
  5. Calculation of shift allowance affected by overtime and overnight shifts
    By danb1985 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-09-2014, 06:16 AM
  6. Timesheet calculation for overtime and double overtime
    By eortega in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-29-2013, 03:28 PM
  7. Day shift/night shift time calculation issue
    By STATEXCEL in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-31-2007, 08:48 AM

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