Convert Time...!convert tenths of a second

[Guest]

How can i convert tenths of a second to time (Hours, min,sec ). Can this
happen with macro..?

 

[Guest]

Hi
try the following formula
=A1/(24*60*60*10)
and format the resulting cell as time

 

[R.VENKATARAMAN]

try custom format
[h]:mm:ss.0

if not available introduce it.
you will get for e.g.
10:13:12.5
is this what you want