+ Reply to Thread
Results 1 to 5 of 5

Calculating over time

  1. #1
    Registered User
    Join Date
    05-26-2013
    Location
    canada
    MS-Off Ver
    Excel 2007/2013
    Posts
    3

    Calculating over time

    im building a time sheet and i need some help

    I have a Range that has all my hours worked B3:B17

    I work 7 hours a day

    if i work over 7 hours i want it to count the Number of hours im over (if i work 10hours one day and 8 hours the next i want it to count 4)

    also it cant lower the number if i only work 6 hours eg. =SUM((B3-7),(B4-7),....)

    cant seem to get it to work

  2. #2
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: Calculating over time

    Hi Bondo,

    Can you post your worksheet? Makes it far easier to provide a solution if we can see the data layout.

    S.
    If I've been of help, please hit the star

  3. #3
    Registered User
    Join Date
    05-26-2013
    Location
    canada
    MS-Off Ver
    Excel 2007/2013
    Posts
    3

    Re: Calculating over time

    Here you go

    Skycomp Time Sheet1.xlsx

  4. #4
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: Calculating over time

    Try this in cell B20.

    =SUMIF(B3:B17,">7",B3:B17)-(COUNTIF(B3:B17,">7")*7)

    You can then copy it to D20 too.

    Does that do what you mean?

  5. #5
    Registered User
    Join Date
    05-26-2013
    Location
    canada
    MS-Off Ver
    Excel 2007/2013
    Posts
    3

    Re: Calculating over time

    Thanks! 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