Excel Forum

Mr Excel & excelisfun Trick 73: Coax Time Value From Text: MOD, LEFT, RIGHT, TEXT, MOD Functions

See Mr Excel and excelisfun use the functions MOD, LEFT, RIGHT, TEXT, TIMEVALUE, and MOD to coax a time value from a time value stored as text:
1) From 0905a to 9:05 AM
2) From 1010p to 10:10 PM

Got a Question? Ask it Here in the Forum.