+ Reply to Thread
Results 1 to 4 of 4

Calculate total hours

  1. #1
    Forum Contributor
    Join Date
    08-19-2012
    Location
    Sydney
    MS-Off Ver
    MS Office 365/16
    Posts
    282

    Calculate total hours

    Hi...Please see attached.

    I am trying to calculate total hours of work for a sporting season. If you go to cells B19 and C19 you will see a formula i have. This was working fine until i decided to add in more information to cell B36, B52, B68 etc...(In brackets is the total of hours worked for those two weeks). Would it be possible to somehow still read the cells minus the part i have in brackets?

    Thanks,
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    08-19-2012
    Location
    Sydney
    MS-Off Ver
    MS Office 365/16
    Posts
    282

    Re: Calculate total hours

    or another option...calculate groups of 7 rows.

    So calculate row B21:B27, B29:B35, etc...

  3. #3
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: Calculate total hours

    Perhaps if you are consistent with your typing of the total hours

    =SUMIF($A$21:$A$308,"<>Total Hours =",$B$21:$B$308)

  4. #4
    Forum Contributor
    Join Date
    08-19-2012
    Location
    Sydney
    MS-Off Ver
    MS Office 365/16
    Posts
    282

    Re: Calculate total hours

    yep..that seems to do the job. Thanks

+ 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] Formula to calculate hours worked w/lunch or w/o + OT column only total after 40 hours
    By blinhart in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-31-2023, 11:14 AM
  2. [SOLVED] Calculate Total Hours
    By Billy Spivy in forum Excel General
    Replies: 4
    Last Post: 02-02-2018, 11:57 AM
  3. [SOLVED] Calculate Total Hours each occurrence and Total Days for all occurences
    By CARD17 in forum Excel Formulas & Functions
    Replies: 47
    Last Post: 01-18-2017, 11:02 PM
  4. Calculate Total Hours
    By sabubakaralis in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-02-2015, 09:15 PM
  5. Replies: 14
    Last Post: 10-08-2014, 11:31 PM
  6. [SOLVED] How do I calculate total hours by rate of pay?
    By FrankF in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  7. How do I calculate total hours by rate of pay?
    By Aladin Akyurek in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 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