How might I do this

[Rich]

I have a spreadsheet I use to calculate total hours worked per day, I then
record those hours in another column by date so I can track total hours by
week and still retain the hours each day.
A B
1/03/04 7.5
1/04/04 7.8
Total 16.3 (where total would be the weekly total)

and so on.

Is there a way to have the the hours appear in the appropriate cell in
column B based on the date in column A?
I can get the hours to record properly using an "If A=today()" type formula
but cannot get the hours in B to be retained if "A" isn't today's date.

Thanks,
Rich

 

[Peter Atherton]

-----Original Message-----
I have a spreadsheet I use to calculate total hours worked per day, I then
record those hours in another column by date so I can track total hours by
week and still retain the hours each day.
A B
1/03/04 7.5
1/04/04 7.8
Total 16.3 (where total would be the weekly total)

and so on.

Is there a way to have the the hours appear in the appropriate cell in
column B based on the date in column A?
I can get the hours to record properly using an "If A=today()" type formula
but cannot get the hours in B to be retained if "A" isn't today's date.

Thanks,
Rich

You can use the fact that the date has not been entered.
e.g. =IF(A5>0,7.5,"")
But then you would need another column for overtime. If
you only want to add the hours on say Friday use the
formula =IF(WEEKDAY(TODAY())=6,SUM(B5:B9),"") or to link
it to a cell date =IF(WEEKDAY(A9)=6,SUM(B5:B9),"")

Regards
Peter