Convert from standard notation to time does not work

Question

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. Does anyone know what to do. In this format i can not use it for proces mining.&nbsp;

gijsl · Answer

Haytham Amairah&nbsp;&nbsp;It is almost perfect but de conversion is wrong with time before noon. For example 93031 is converted to 21:03:31. But it is in de morning en not in the evening. And 84340 is converted in 12:34:40. Do you know what i am doing wrong.&nbsp;

haytham amairah · Answer

Gijsl&nbsp;Hi,&nbsp;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))&nbsp;Hope that helps&nbsp;

preagan · Answer

Hello&nbsp;Gijsl,&nbsp;Are you looking to convert&nbsp;164833 into the format&nbsp;16:48:33?&nbsp;Sincerely,PReagan

danmcg · Answer

Gijsl&nbsp; so if you have a serial date (just a number), then use this formula in a cell (like D8) '=TEXT(C8,"m/d/yyyy")'&nbsp;does that help?

danmcg · Answer

whoops, missed the boat on that one, ignore this:

Forum Discussion

Convert from standard notation to time does not work

10 Replies

Resources