Force Time Values
Posted on 2013-01-25
I have a spreadsheet that I deployed to a few employees to test throughout the day. While I have no difficulty typing in time values the proper way for Excel (IE ##:## AM). I noticed each employee typed it slightly different, and it created problems with my spreadsheet.
Examples of how the user typed in time values "5:00PM" resulted in errors, and "1:00" resulted in 1:00 AM, when the user really wanted 1:00 PM.