• This will be helpful when user time format is in hh:mm AM/PM
• Follow the bellow steps to create a custom field that will convert the time am/pm to 24 hour time.
• Create the Time field.
  • Go to Setup – Customization – Lists, Records, & Fields – Entity Fields – New.
  • Enter label for the field.
  • Set Type as Time of Day.
  • Check the Store Value field.
  • In the Applies to tab – select the record this field should be applied. For example: select Customer.
  • Click Save.
• Create the second field that will convert the time am/pm to military time.
  • Go to Setup – Customization – Entity Fields – New.
  • Enter label for the field.
  • Set Type as Free-Form text.
  • Uncheck the Store Value field.
  • In the Applies to tab – select the record this field should be applied. For example: select Customer.
  • In the Validation & Defaulting tab – Default Value = “to_char({field ID in step A},’hh24:mi’)” and check the Formula field.
  • Click Save.

When custom field type is changed, the values stored in that field will be lost due to the change since most field types do not hold the same value.

Note: After field type was changed, logs on the System Notes will be deleted for this field due to the change so there will be no way of retrieving the value of the field.

Example 1: If custom field type is changed to Currency from Integer Number, New field has the value of old field.

Example 2: If a custom field type is changed to Integer Number from Phone Number, Old field value gets deleted.