Time Value Fields

When a field requires a Time Value, the value must be formatted in 24-hour time. This means after noon, the hour value entered should have 12 added to the hour value shown on the clock. For example, if the time is 3:00 pm, the correct value in 24-hour format is 15:00 (12+3 = 15).

• The system automatically formats entered values to hh:mm (two-digit hour value, two-digit minute value separated by a colon).
  • Enter 1500 and the system automatically adds the colon between the hour and minute values to convert this to 15:00.
  • Enter 900 and the system adds the leading zeros and colon to convert this to 09:00.
  • The system adds leading zeros to any value less than 4 digits. For example, if 9 is entered, the system converts this to 00:09 (nine minutes after midnight).
  • If the last two digits of the entered value is larger than 59, this cannot be converted to a valid time and an error message is generated.
  • If the first two digits of a four-digit value is larger than 23, this cannot be converted to a valid time and an error message is generated.
  • Enter midnight as 00:00; enter noon as 12:00.
• If a "p" or "pm" is entered after the hour value, the system automatically converts the time to the corresponding afternoon value in 24-hour time. For example:
  • Enter 300p or 300pm and the system converts this to 15:00 and adds the colon.