Excel Forum
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



Excel Magic Trick 446: Time In & Time Out in Same Cell Bad Setup Leads To Complicated Formula


See how to create a formula for calculating time worked when the time in and time out are entered into the same cell. This complicated formula comes from the fact that the data is setup badly. See the functions REPLACE, FIND, LEFT, TRIM, IF and OR.
Learn about how array syntax in the OR function can avoid Ctrl + Shift + Enter.





Got a Question? Ask it Here in the Forum.