Excel Forum

Excel Magic Trick 721: Convert Text Time Numbers Without A Colon To Time 0655 into 06:55 AM

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/

Got a Question? Ask it Here in the Forum.