Forum Discussion
convert numbers to time
Hi I am trying to convert a number format in one cell to time format in another cell. Here is my example In cell A1 I have a number 1.90 and I need it to be converted into 1:90 in cell B1. what for...
Here again a file with the example from 1.9 to 1:90.
One would only have to format 1.9 as text.
But if you want it to remain time and to be seen as time then here is a link and a formula.
Insert colon between numbers to make them as time format with formulas
=TIME(LEFT(A1,LEN(A1)-2),RIGHT(A1,2),0)
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)