+ Reply to Thread
Results 1 to 5 of 5

Calculate total hours worked, between two dates (start and finish)

  1. #1
    Registered User
    Join Date
    06-25-2012
    Location
    Perth, Australia
    MS-Off Ver
    Office 2010
    Posts
    3

    Calculate total hours worked, between two dates (start and finish)

    I have a product line consisting of 4 resources (A,B,C,D) and the hours per day (averaged) they do. These columns have varying hours depending on dates. I have an on the spot date where i want to know how many hours of A,B,C,D (seperately) will be used per day. I have over 1000 "on the spot" dates i need to check. I've been trying to use SUMIFS but had no luck.


    Start_Date -- Finish_Date --- A -- B -- C-- D
    01/01/2011 -- 01/03/2011 -- 10-- 5 -- 4 -- 3
    10/02/2011 -- 10/05/2011 -- 7 -- 6 -- 2 -- 1
    15/02/2011 -- 10/05/2011 -- 8 -- 7 -- 2 -- 2

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,048

    Re: Calculate total hours worked, between two dates (start and finish)

    What are your regional settings?

  3. #3
    Registered User
    Join Date
    06-25-2012
    Location
    Perth, Australia
    MS-Off Ver
    Office 2010
    Posts
    3

    Re: Calculate total hours worked, between two dates (start and finish)

    Not sure what you mean. I havent changed anything.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,048

    Re: Calculate total hours worked, between two dates (start and finish)

    Are the dates mm/dd/yyyy or dd/mm/yyyy?

  5. #5
    Registered User
    Join Date
    06-25-2012
    Location
    Perth, Australia
    MS-Off Ver
    Office 2010
    Posts
    3

    Re: Calculate total hours worked, between two dates (start and finish)

    . The last start date proves dd/mm/yyyy

+ 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