Forum Discussion
Convert from standard notation to time does not work
JI have loaded date from a database and want to convert that data to time but it does not work. The format is now standard en looks like this. 164833. If i convert it to time then it becomes 00:00:00...
Treating the original as a number, convert first to correctly formatted text, then back to a time value
= TIMEVALUE( TEXT(number, "00\:00\:00") )