Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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..? |
#2
|
|||
|
|||
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..? |
#3
|
|||
|
|||
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..? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help Q: Entering 7 p time format, does not convert to 19:00 | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Convert text file to MS_Excel | Excel Discussion (Misc queries) |