Excel Forum
Similar Content
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
Countdown Timer in Excel
Tutorial: How to create a countdown timer in Excel. This allows you to display a timer in whatever c...
Dynamic Formulas that Update When you Add Data in Excel
Tutorial: I'll show you how to make formulas and functions that automatically update when more data...

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.