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

Top