+ Reply to Thread
Results 1 to 5 of 5

Timesheet calculation

  1. #1
    Registered User
    Join Date
    07-09-2014
    Location
    London
    MS-Off Ver
    2010
    Posts
    2

    Timesheet calculation

    Hello and greetings.

    I have a challenge with a calculation, which I hope can be simply overcome. I am creating a timesheet for three people. The columns headings are Date, Phase, Name, Description, Comment, Hours spent. I want to have some of this information automatically calculated in a small table, to show the progress for number of hours by each of us. I have uploaded a screenshot so you can see.

    In a cell on the same sheet the calculation should work out if 'Name' is Joseph then calculate total 'Hours spent' for Joseph. I will then do the same with the other two names.

    I am sure this is possible but I am having so much difficulty figuring it out.

    Thank-you very much in advance for any help.

    Joseph
    Attached Images Attached Images

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Timesheet calculation

    How about:

    Please Login or Register  to view this content.
    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: Timesheet calculation

    rather than an image can you attach a sample spreadsheet - your image is small

    you can probably use a SUMIF()

    =sumif( $C$2:$C$18, H$2, $F$2:$F$18)
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  4. #4
    Registered User
    Join Date
    07-09-2014
    Location
    London
    MS-Off Ver
    2010
    Posts
    2

    Re: Timesheet calculation

    Yes! Thank-you both very much. It works perfectly. Many, many thanks for such fast response!

    With best regards

    Joseph

  5. #5
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: Timesheet calculation

    your welcome

    if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here

+ 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] Timesheet Calculation Help
    By jeci80 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-19-2014, 12:04 PM
  2. Timesheet calculation
    By sinternational in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-03-2013, 09:34 AM
  3. Help with timesheet calculation
    By amexjunkie in forum Excel General
    Replies: 3
    Last Post: 11-04-2011, 02:24 AM
  4. Timesheet Calculation
    By btoti in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-18-2006, 03:30 PM
  5. Timesheet calculation
    By candlekeeper in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-25-2006, 03:41 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