I have a database with time as text. The formula I have to convert time when it is shown as example "1230", converts to 12:30.
But when I have time that shows a 9 ( Minutes) or 53 (minutes) it comes up #VALUE.

Here is the formula am using =TIMEVALUE(LEFT(E2,LEN(E2)-2)&":"&RIGHT(E2,2))

How I change it make cells with only minutes convert?

Thanks