Millisecond

[Peterso]

I have a time value in a cell A1, say 40.56 second. I know I can get the second of 40 by writing x=Second(cells(1,1)). I would like to know how can I get the 0.56? It seems that it doens't have a funcation Millisecond. Thanks.

 

[joeu2004]

I have a time value in a cell A1, say 40.56 second. I know I can get the second of 40 by writing x=Second(cells(1,1)).

Actually, no you cannot

Not if the cell value is seconds as a decimal number -- literally 40.56.

And not even if the cell value is Excel time 0:0:40.56 formatted as .00 .

In the latter case, note that SECOND(A1) returns 41, not 40, because Excel rounds to the second.

I would like to know how can I get the 0.56?

It is unclear exactly what you want. 40.56 is 40 sec 560 milliseconds, not 56 milliseconds.

If the value in A1 is decimal seconds (literally 40.56):

seconds: INT(ROUND(A1,2))

milliseconds: 10*MOD(ROUND(100*A1,0),100)

Try with 40.556 and 40.996 formatted as Number with 2 decimal places.

----

If the value in A1 is Excel time 0:0:40.56 formatted as .00 :

seconds: INT(TEXT(A1,".00"))

milliseconds: 10*RIGHT(TEXT(A1,".00"),2)