Is there any way to format a cell to display time to the millisecond?
P Patrick C. Simonds Oct 29, 2008 #1 Is there any way to format a cell to display time to the millisecond?
B Bernard Liengme Oct 29, 2008 #3 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
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
P Peo Sjoblom Oct 29, 2008 #4 TIME can only use integers, it works like you would have INT inside it -- Regards, Peo Sjoblom
P Peo Sjoblom Oct 29, 2008 #5 One way when using TIME to add 125 milliseconds <g> =TIME(3,4,5)+(125/24/60/60/1000) -- Regards, Peo Sjoblom
One way when using TIME to add 125 milliseconds <g> =TIME(3,4,5)+(125/24/60/60/1000) -- Regards, Peo Sjoblom
