Results 1 to 2 of 2
Thread: Time In Excel (Excel 97)
2002-11-26, 00:33 #1
- Join Date
- Nov 2002
- Waynesboro, Virginia, USA
- Thanked 0 Times in 0 Posts
Time In Excel (Excel 97)
I am helping a swim team develop a data base using Excel. Swim times are in minutes, seconds and then tenths and hundreds. Example - 01:23.48 - One minute, 23 seconds and 48 hundreds. I have been unable to get Excel to accept this - it keeps wanting to make it a time on a clock (AM or PM). Is there a way to format Excel so it will accept this for what it is? And if so, would it then do calculations like the average?
This is my first post so please excuse me if I have done this wrong. I am still reading the rules.
Thanks for any help.
2002-11-26, 03:46 #2
- Join Date
- May 2002
- Canberra, Australian Capital Territory, Australia
- Thanked 420 Times in 349 Posts
Re: Time In Excel (Excel 97)
Use a custom format for the cells:
Excel will still hold the value as a time of day (shown as hh:mm:ss in the formula bar), but will display as you want in the cells. Now, a value of 01:23.45 will show correctly as that in the cell, and as 12:01.23 AM in the formula bar - hundreths of seconds don't show in the formula bar. Since times in Excel start from midnight, the 12 AM part is effectively 0hrs, which is what you want. So, math functions like additions, multiplications, averages etc will work just fine.
[MS MVP - Word]