Convert Time...!convert tenths of a second
 

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

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

"Pape" wrote:

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

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




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