+ Reply to Thread
Results 1 to 4 of 4

40 Hours per week / how to calculate overtime hours

  1. #1
    Registered User
    Join Date
    03-06-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    2

    40 Hours per week / how to calculate overtime hours

    Hi, I am almost there with my spreadsheet, but need a little help.

    See my attached sheet. all I need to do is:- My working week is 40 hours, I have calculated all my hours into travel, labour, office hours. I just need to calculate the amount of overitme based on the total for that week against standard 40 hours.

    As the weeks go by, I will be adding a workbook for each week so will then need a running total for each segment.
    Please can you help.
    Attached Files Attached Files
    Last edited by hudsonic72; 03-07-2013 at 02:34 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: 40 Hours per week / how to calculate overtime hours

    =d52-"40:00"
    Ben Van Johnson

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: 40 Hours per week / how to calculate overtime hours

    You can put this formula in the merged cells I5:I10

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Ensure that the cells are formatted as Wrap text, and then you can copy that block of cells into the other blocks for the other days of the week.

    You can also use this formula in G50:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    to work out the overtime hours.

    Hope this helps.

    Pete

  4. #4
    Registered User
    Join Date
    03-06-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    2

    [SOLVED] Re: 40 Hours per week / how to calculate overtime hours

    Thanks for your help. It works great.

+ 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