Excel Forum

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.