Excel Forum
Similar Content
PV Function - Get the Present Value in Excel
Tutorial: The Present Value (PV) function in Excel will return the current value of an investment.Â...
Increment a Value Every X Number of Rows in Excel
Tutorial: (New Easier Version for Excel 2010 and Later) How to increment a value, number, percent, e...
Formula to Delete the First or Last Word from a Cell in Excel
Tutorial: Excel formula to delete the first or last word from a cell. You can copy and paste the fo...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.