+ Reply to Thread
Results 1 to 5 of 5

Calculate and lookup last weeks total hours worked from a table without #N/A error message

  1. #1
    Registered User
    Join Date
    12-20-2008
    Location
    Perth, Western Australia
    MS-Off Ver
    Microsoft - Office Enterprise 2007
    Posts
    28

    Calculate and lookup last weeks total hours worked from a table without #N/A error message

    Sorry - forgot to include that I need a row to show yesterday's totals too!

    Ooops!


    I have a table with some already completed and working formulas - need an extra three cells calculated.

    Basically the table records hours worked at two sites
    Then looks up today's values, and year to date.

    Needs a formula to calculate and show last weeks totals too

    The week for reporting purposes is Thursday till the following Wednesday
    Attached Files Attached Files
    Last edited by thetaplus; 06-18-2014 at 02:44 AM.

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Calculate and lookup last weeks total hours worked from a table without #N/A error mes

    Hi

    Formula calculates the total hours(in column C) starting from last Thursday until Today(Wednesday).

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Is this what are you looking for?
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    12-20-2008
    Location
    Perth, Western Australia
    MS-Off Ver
    Microsoft - Office Enterprise 2007
    Posts
    28

    Re: Calculate and lookup last weeks total hours worked from a table without #N/A error mes

    Hello and thank you

    I must be doing something wrong with the formula you have provided. I think the answers should be in the last week's total
    138:53:00 108:34:00 247:27:00

    What am I missing please?

  4. #4
    Registered User
    Join Date
    12-20-2008
    Location
    Perth, Western Australia
    MS-Off Ver
    Microsoft - Office Enterprise 2007
    Posts
    28

    Re: Calculate and lookup last weeks total hours worked from a table without #N/A error mes

    this attached file has the last weeks' and yesterdays cells - sorry for the stuff up!
    Attached Files Attached Files

  5. #5
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Calculate and lookup last weeks total hours worked from a table without #N/A error mes

    Formula calculates from 12/06/2014(last THURSDAY) TO 18/06/2014(WEDENSDAY)

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    You get the results that you mentioned, using this formula.
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    For yesterday's results use this one.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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: 1
    Last Post: 06-14-2013, 02:09 AM
  2. Replies: 4
    Last Post: 02-12-2013, 07:01 AM
  3. Replies: 2
    Last Post: 02-11-2013, 02:26 PM
  4. Replies: 4
    Last Post: 06-26-2012, 02:19 AM
  5. Excel 2007 : Calculate total hours worked
    By elexiahope in forum Excel General
    Replies: 3
    Last Post: 01-23-2011, 04:18 PM

Tags for this Thread

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