time format

L

Louis & Nanci

Hi,

I am a statistician for a swim team. How can I format a cell to recognize
time in the following format: minutes:seconds.tenths/thousandths? I need
Excel to see the difference between 59 seconds and 9 tenths or 59.90. Any
suggestions?

Louis
 

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

Similar Threads

Formatting for and adding thousandths of a second 5
I need Time Range to return Value 4
Inconsistent formatting of section numbers 0
Excel does not accept text format! 0
Need formula for calculating time 2
Paste to excel from word - auto format problem 1
Need a formula for time conversion 6
Shared Link is showing empty notebook 1

Top