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
Last edited by thetaplus; 06-18-2014 at 02:44 AM.
Hi
Formula calculates the total hours(in column C) starting from last Thursday until Today(Wednesday).
Formula:
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.
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?
this attached file has the last weeks' and yesterdays cells - sorry for the stuff up!
Formula calculates from 12/06/2014(last THURSDAY) TO 18/06/2014(WEDENSDAY)
Formula:Please Login or Register to view this content.
You get the results that you mentioned, using this formula.
Formula:Please Login or Register to view this content.
For yesterday's results use this one.
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks