Forum Discussion
Solved
Converting numbers to excel time
Hello, I'm wanting to know how to convert numbers with decimals into excel formatted time. I have thousands of cells so I can't change them all manually. For example, I have written the time in...
A number can have only one decimal separator, so 8.36.10 is not a number but a text value.
With such value in A2 and below, enter the following formula in B2:
=TIMEVALUE(SUBSTITUTE(A2,".",":"))
Format the cell with the formula as time, then fill down.
A number can have only one decimal separator, so 8.36.10 is not a number but a text value.
With such value in A2 and below, enter the following formula in B2:
=TIMEVALUE(SUBSTITUTE(A2,".",":"))
Format the cell with the formula as time, then fill down.
Thank you very much Hans, this has worked.
