P
Patrick C. Simonds
Is there any way to format a cell to display time to the millisecond?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
hh:mm:ss.000
--
Regards,
Peo Sjoblom
--
Regards,
Peo Sjoblom
B
Bernard Liengme
Peo,
What am I doing wrong?
Cell has =TIME(3,4,5.125) and is formatted as hh:mm:ss.000 but displays
3:04:05.000
Thanks
What am I doing wrong?
Cell has =TIME(3,4,5.125) and is formatted as hh:mm:ss.000 but displays
3:04:05.000
Thanks
P
Peo Sjoblom
TIME can only use integers, it
works like you would have INT inside it
--
Regards,
Peo Sjoblom
works like you would have INT inside it
--
Regards,
Peo Sjoblom
P
Peo Sjoblom
One way when using TIME to add 125 milliseconds <g>
=TIME(3,4,5)+(125/24/60/60/1000)
--
Regards,
Peo Sjoblom
=TIME(3,4,5)+(125/24/60/60/1000)
--
Regards,
Peo Sjoblom
B
Bernard Liengme
Many thanks