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...
Hi,
If this notation 164833 means hhmmss, then you can use this formula to convert it to proper time format:
=TIME(LEFT(A1,2),MID(A1,3,2),RIGHT(A1,2))
Hope that helps
