Time Sheet Summary

F

FMW

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
 
D

David Biddulph

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/s....excel.*+author:[email protected] 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" <[email protected]> wrote in messageThis 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top