How do I enter accumulated time as hours, minutes and seconds?

R

Raz

I'm timing myself running laps. I want to enter in my lap times in hours,
minutes and seconds. Example:

24 minutes 28 seconds, put in as either 00:24:28 or 24:28

I then want to average out my lap times in the same format. Can anyone help
me?
 
T

Tyro

Enter your time of 24 minutes and 28 seconds as 00:24:38. If you enter it as
24:28, Excel will interpret that as 24 hours and 28 minutes.
You should be able to use the AVERAGE function and format the result as
hh:mm:ss or simply mm:ss

Tyro
 

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

Similar Threads

Calulating hours, minutes and seconds 5
Converting time :: Excell 2007 5
sum total of hours minutes seconds in excel 2003 2
Converting Seconds to Hours, Minutes, Seconds 3
How do I change a minutes and seconds as a 2400 time to seconds? 1
How do I convert hours, minutes, and seconds into decimal format? 2
How do I sum increments of minutes and seconds 5
dispay numbers as minutes and seconds in excel 2

Top