The hours I've run....

N

nui

Hi there, I'm having trouble finding a way to keep track of the hours
I've trained for my, hopefully successful, marathon. What I want to be
able to to is type in exactly what is on my watch i.e 1.09.25 and at
the end of the week it'll tell me how many hours that week I've
trained, or lack thereof!

Thanks if anyone can help.

Nick.
 
D

Dave Peterson

If you enter your times as times, you'll make your life (in excel) easier:
01:09:15
(One hour, 9 minutes, 15 seconds)

Then you can use a formula like:

=sum(b2:b9999)
and format the cell as [hh]:mm:ss
 
D

daddylonglegs

Excel won't recognise 1.09.25 as a time.....but if you use colons it
will. If you enter 1:09:25 then you can sum a column of these just
using

=SUM(A1:A100)

or similar

format result cell as [h]:mm:ss
 
Top