View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RAZ RAZ is offline
external usenet poster
 
Posts: 120
Default How do I enter accumulated time as hours, minutes and seconds?

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?