+ Reply to Thread
Results 1 to 4 of 4

Need Help!! What formula would you use for totaling hours across various projects

  1. #1
    Registered User
    Join Date
    06-29-2017
    Location
    United States
    MS-Off Ver
    2016
    Posts
    27

    Need Help!! What formula would you use for totaling hours across various projects

    In short I am trying to make a simple excel spread sheet to help track hours spent on certain projects.. My problem is in this example I have 3 guys working on various projects (3), all with different hours on different days (dates are not important). I want to have a total on the first sheet that shows how many hours have been spent on each project by each guy (highlighted yellow). I hope that wasn't confusing and the excel spreadsheet can explain itself. Thanks in advance for any help, you all are great!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-12-2017
    Location
    Brazil
    MS-Off Ver
    2016
    Posts
    59

    Re: Need Help!! What formula would you use for totaling hours across various projects

    Good afternoon.
    See if that's what you need.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-29-2017
    Location
    United States
    MS-Off Ver
    2016
    Posts
    27

    Re: Need Help!! What formula would you use for totaling hours across various projects

    That is great, now I just have to try and figure out what you did so i can replicated on google sheets :/

  4. #4
    Registered User
    Join Date
    06-29-2017
    Location
    United States
    MS-Off Ver
    2016
    Posts
    27

    Re: Need Help!! What formula would you use for totaling hours across various projects

    NEvermind I got it, awesome 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] Totaling hours in hh:mm format
    By lapot in forum Excel General
    Replies: 17
    Last Post: 12-16-2015, 01:09 PM
  2. Totaling hours
    By OnTheCouch in forum Excel General
    Replies: 2
    Last Post: 08-16-2010, 01:02 PM
  3. [SOLVED] Totaling some hours but not others HELP!
    By vanilla_bean_orange via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-16-2006, 06:10 AM
  4. [SOLVED] Totaling Hours in Standard Format
    By Coco in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. Totaling Hours in Standard Format
    By Coco in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  6. [SOLVED] Totaling Hours in Standard Format
    By Coco in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  7. [SOLVED] looking for template to track hours on projects for employees
    By Kim S in forum Excel General
    Replies: 1
    Last Post: 01-04-2005, 07:06 PM

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