Excel Magic Trick 721: Convert Text Time Numbers Without A Colon To Time 0655 into 06:55 AM
Download Excel Start File https://people.highline.edu/mgirvin/Y...
See Mr Excel Message Board Barry Houdini's cool short formula trick to go from a time of 0655 to 06:55 AM with the TEXT function, backslash to insert a single character in Number Formatting and adding zero to convert text time to time.
Download file: http://people.highline.edu/mgirvin/