how do I format numbers for time with thousandths of a second?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

There are a seemingly simple examples in the help tab, but for the life of
me, I can't get a simple cell format for minutes, seconds and thousndths of a
second to work properly. The cell number looks right, but I get some
bastardized date up in the input bar that doesn't match -- ultimatley I want
to add times.

frustrated
 
should be mm:ss.000

On Sun, 30 Jan 2005 19:50:11 -0800, Mike Stoller <Mike
 
Since you know how to format the cell in time or
you have to do is be careful with your input 7:52:00 NOT 7.52.00
you must use the double dots
Cheers
peterm
 
You must log in or register to reply here.

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

how can I work with lap times? 6
Formatting for and adding thousandths of a second 5
Formating seconds into mm:ss 4
Varied accuracy custom number formats 3
Time format in Excel 1
i want to convert decimals into time format 3
How do I stop Excel from copying date format from cell above? 2
Difference between two times in seconds 1

Back
Top