This was what I said too, but our Controller expects stupid users who
won't use the spreadsheet unless they can do it their way. It's a
lost cause as far as I'm concerned, but I had to try.

Thanks all for the other suggestions.


On Jun 23, 8:04 am, "Bernie Deitrick" <deitbe @ consumer dot org
wrote:
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