Hi

check out the SUMIF function, if you need more assistance, please post back
with details of how your worksheet is structured (ie what column has dates
and what column are you adding up to get the time).

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"frustratedwthis" wrote in
message ...
I have a spreadsheet that keeps up with personal time. The time rolls off
after a year from the date it was taken. How would I set up a formula to
automatically roll these hours off? I am ata loss. Thanks in advance!