Convert Time...!convert tenths of a second

P

Pape

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

Frank Kabel

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting minutes to tenths 2
To make pdf to work as word 1
Need to convert hours and minutes to hours and tenths. 2
Excel time conversion - Please help!! 5
Need formula for calculating time 2
Countdown Timer 1
Displaying time gaps 6
Average time for a race in minutes seconds & tenths 1

Top