Closed Thread
Results 1 to 4 of 4

Formula to Calculate Normal Hours, Time & 1/2 & Double Time from Daily Hours per week

  1. #1
    Registered User
    Join Date
    02-13-2014
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    26

    Formula to Calculate Normal Hours, Time & 1/2 & Double Time from Daily Hours per week

    I am trying to do a spreadsheet with the daily hours of each employee for the week and then at the end have these divided into Normal Hours, Time & 1/2 and Double Time automatically. So when we manually enter in the total hours worked for each day it will calculate overtime automatically for the whole week.

    Normal Hours are 7.6 per day, Time 1/2 is 2 hours and Double time is all hours after that per day.
    My format is simple as per below but I cannot work out how to do a formula that will take the overtime hours from each day for the whole week and have the answer calculate into 1 cell for Normal, Time 1/2 & Double Time.

    Wed Thur Fri Sat Sun Mon Tues Total Normal Hours Time 1/2 Double Time
    10 10 10 6 8

    Any help would be much appreciated.
    Thanks

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Formula to Calculate Normal Hours, Time & 1/2 & Double Time from Daily Hours per week

    Is this solved?

    If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    02-13-2014
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Formula to Calculate Normal Hours, Time & 1/2 & Double Time from Daily Hours per week

    Sorry this was a duplicate thread and has been answered in the following:

    http://www.excelforum.com/excel-form...ml#post3584647

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Formula to Calculate Normal Hours, Time & 1/2 & Double Time from Daily Hours per week

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Timesheet that calcs time in, time out, lunch used, reg hours, ot hours, double hours
    By noobface in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-21-2021, 03:45 AM
  2. [SOLVED] Need Formula to Calculate Overtime from Daily hours for a whole week
    By KazzICC in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-13-2014, 08:05 PM
  3. If time period falls outside of normal working hours how many hours does it add.
    By chrisdromey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-02-2013, 11:56 PM
  4. Subtracting hours from time to calculate overtime hours
    By nabilishes in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-16-2012, 08:56 AM
  5. Calculating Time and Half and Double Time (After 40 hours worked)
    By DoreenBassett in forum Word Formatting & General
    Replies: 1
    Last Post: 02-20-2009, 10:01 AM

Tags for this Thread

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