LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting hours, minutes, seconds, to hours chouck Excel Worksheet Functions 7 January 29th 08 08:00 PM
Formula to Change Hours:Minutes:Seconds to Seconds only Cheri Excel Discussion (Misc queries) 4 August 30th 06 12:44 AM
Converting hours:minutes:seconds to just minutes Dan Vagle Excel Worksheet Functions 3 July 17th 06 11:20 PM
enter time in simple text and convert to hours/minutes YanYan Excel Discussion (Misc queries) 5 June 23rd 06 03:00 AM
Convert "Time Interval" in "hours : minutes : seconds" to seconds Ianukotnorth New Users to Excel 7 May 8th 05 08:11 PM


All times are GMT +1. The time now is 12:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"