LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default show time to hundreds of a second

I'm sure this has been asked before but I do need help.
I'm a college athlete and need to keep a record of my times. If I use Excel to input my time of 1minute 48.76 seconds it usually displays as a date. How can I display my times down to hundreds of a second? (1.48.76 or 01.48.76) 1 minute 48 point 76 seconds. Thank you in advance x
 
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
Formating tenths and hundreds to show as whole numbers Nelson B. Excel Discussion (Misc queries) 3 March 15th 10 08:00 PM
hundreds separator Viraj Nayaka Excel Discussion (Misc queries) 2 September 6th 06 12:09 PM
Convert Hundreds to Thousands abs Excel Discussion (Misc queries) 2 April 5th 06 05:06 PM
Show timesheet time in and out in regular time versus military tim John Excel Worksheet Functions 1 November 11th 05 05:14 AM
Excel should let me enter time in one hundreds of a second. mrvw Excel Discussion (Misc queries) 3 August 31st 05 05:47 PM


All times are GMT +1. The time now is 10:24 AM.

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"