+ Reply to Thread
Results 1 to 2 of 2

Complex Formula (Tracking Worked Hours)

  1. #1
    Registered User
    Join Date
    03-11-2014
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003
    Posts
    5

    Complex Formula (Tracking Worked Hours)

    I need to create a formula for the following situation

    Cell A1 will contain numbers (1-8) relating to people.
    Cell A2 will contain a Total Time for a shift worked (ie. 4:00hours).
    Cell A3 will contain the persons (ie. 1) total time worked.

    I need a formula to say that if A1=1 then add A2 to A3

    I will eventually have 8 people. So the formula will need to contain 8 if's I guess.

    Help please...

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,607

    Re: Complex Formula (Tracking Worked Hours)

    I would see it rather different way.
    In A1 write "ID" in B1 "time"
    in A2 and B2 write data for first worker first day
    A3 and B3 second worker first day (or first worker second day)
    and so on fill down

    then in D1 write again headter "ID" in D2 write first ID in D3 second ...
    in E1 write "Total" and in E2 write formula:
    =SUMIF(A:A,D2,B:B)
    use Custom format (Ctrl+1) [hh]:mm for this cell
    copy formatted formula down.
    Best Regards,

    Kaper

+ 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. Replies: 4
    Last Post: 02-12-2013, 07:01 AM
  2. Replies: 2
    Last Post: 02-11-2013, 02:26 PM
  3. Replies: 0
    Last Post: 05-14-2012, 05:36 PM
  4. Calculating basic hours worked, between a time range and premium hours worked
    By RoyLittle0 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-07-2012, 06:59 AM
  5. Replies: 0
    Last Post: 01-05-2012, 06:23 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