Excel Excel - time format - milliseconds


yas

Joined
Oct 18, 2008
Messages
1
Reaction score
0
Hello,

Can I format a cell to show time including milliseconds? I want later on to use the milliseconds in a formula in another cell.
The time format needed is:
Minutes:Seconds.milliseconds
I used the format: mm:ss.00
It shows the time I wanted, for example 03:10.87 but then I want to use the milliseconds in a formula and couldn't, Excel was ignoring the 87.

Thanks
 
Ad

Advertisements


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

Top