The problem was that a user may enter
something that isn't recognized by Excel as a time - for example,
"10am".

You could use Data Validation, and require time entry, with a message
explaining what a valid entry looks like.

Bernie