Transforming seconds to milliseconds

[Lu789]

Hi there!

I've got a data set with seconds (example: A1=1.2) and then I transformed it to time using =TIME(0,0,A1) and the format [h]:mm:ss.000 but it's showing 00:00:01.000 instead of 00:00:01.200.

I don't know how to get the milliseconds!!!

Can anyone there help me?

Thanks!

 

[thisoldman]

The TIME function may lose the fractional part of a second.

Instead, I would use the formula =A1/24/60/60 and then custom format to [h]:mm:ss.000 .