Time Sheet Summary
 

This is the 3rd time I am posting...is this visible?: Also, why can't I find
questions I posted?

-- I am having a problem with time sheet reporting. We have a weekly
timesheet which hourly employees complete every week. Most have been saving
EACH timesheet. That is 52 timesheet tabs.
What I am trying to accomplish is this:
Use the time sheet, and have the TOTALS of each column transfer to a single
worksheet. Example of columns in weekly timesheet:
DAte Day of Week Reg OT Sick Vac Total Hours Lunch
Time Used

The date column is filled with date beginning on a Sunday, ending Saturday.
There are formulas to calculate the total hours.

The last row of the weekly timesheet has TOTALS for the week:
w/e Date Reg OT Sick Vac Total Hours LunchTime
Used
12/19 40 5 45
2.5

I am trying to get the last row (totals) to transfer to a separate sheet
using a formula. The sheet is what I call the W/E Totals.
This Totals sheet has the same columns as the weekly timesheet. So, for
instance, for W/E 12/19, this sheet would show the above total weekly hours.
When I complete next week's Timesheet, the dates are changed on that single
timesheet to reflect the new w/e date. I want the totals of that weekly
timesheet to transfer to the TOTALS worksheet. So the resulting time sheet
would have cumulative information from each WEEKLY TIME SHEET, for example
w/e Date Reg OT Sick Vac Total Hours LunchTime
Used
12/05 40 5 45
2.5

12/12 40 2 2
2.5

12/19 40 0 42
2.5


I've tried this formula =IF($A3='Weekly Time Sheet'!$C$4,'Weekly Time
Sheet'!C$17)but it doesn't work....it then gives a "FALSE" for the previous
week's information. '$A3 being the week ending date on the TOTALS
worksheet (same week endings as on the weekly Time sheet). 'Weekly Time
Sheet' being the sheet where daily hours are entered on weekly basis. $C$4
is the week ending date on the weekly timesheet. C$17 being the Totals row
of the weekly time sheet; C$17 is the Regular Hours Column; D$18 is the OT
column, etc., etc.....

Sorry for so much information. Looking forward to a formula that will work.
Sincerely,

Thank you for your help. FMW

Time Sheet Summary
 

Yes, this is visible, as were your previous two postings, and the replies
thereto.

My short answer to why you can't see them is that you are using Microsoft's
web interface to the newsgroup, and that interface isn't reliable.
Only your second attempt, and the reply to that, is visible on Google's
archive at
http://groups.google.co.uk/groups/se....microsoft.com but all 3 threads are visible using a newsreader to access the microsoftnews server, so (as usual) that is the best way to read the group.--David Biddulph"FMW" wrote in ... This is the 3rd time I am posting...is this visible?: Also, why can't Ifind questions I posted? -- I am having a problem with time sheet reporting. We have a weekly timesheet which hourly employees complete every week. Most have beensaving EACH timesheet. That is 52 timesheet tabs. What I am trying to accomplish is this: Use the time sheet, and have the TOTALS of each column transfer to asingle worksheet. Example of columns in weekly timesheet: DAte Day of Week Reg OT Sick Vac Total Hours Lunch Time Used The date column is filled with date beginning on a Sunday, endingSaturday. There are formulas to calculate the total hours. The last row of the weekly timesheet has TOTALS for the week: w/e Date Reg OT Sick Vac Total Hours LunchTime Used 12/19 40 5 45 2.5 I am trying to get the last row (totals) to transfer to a separate sheet using a formula. The sheet is what I call the W/E Totals. This Totals sheet has the same columns as the weekly timesheet. So, for instance, for W/E 12/19, this sheet would show the above total weeklyhours. When I complete next week's Timesheet, the dates are changed on thatsingle timesheet to reflect the new w/e date. I want the totals of that weekly timesheet to transfer to the TOTALS worksheet. So the resulting timesheet would have cumulative information from each WEEKLY TIME SHEET, for example w/e Date Reg OT Sick Vac Total Hours LunchTime Used 12/05 40 5 45 2.5 12/12 40 2 2 2.5 12/19 40 0 42 2.5 I've tried this formula =IF($A3='Weekly Time Sheet'!$C$4,'Weekly Time Sheet'!C$17)but it doesn't work....it then gives a "FALSE" for theprevious week's information. '$A3 being the week ending date on the TOTALS worksheet (same week endings as on the weekly Time sheet). 'Weekly Time Sheet' being the sheet where daily hours are entered on weekly basis.$C$4 is the week ending date on the weekly timesheet. C$17 being the Totalsrow of the weekly time sheet; C$17 is the Regular Hours Column; D$18 is the OT column, etc., etc..... Sorry for so much information. Looking forward to a formula that willwork. Sincerely, Thank you for your help. FMW