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.