Convert format of Time (not Date)

[wibbler]

Hi,

How can I change HH:mm to hh:mm a (essentially converting 24-hour to 12-hour)? There is no date involved in this field, and I see only formats that involve date.

 

[Supreme]

Hey @wibbler

How can I change HH:mm to hh:mm a (essentially converting 24-hour to 12-hour)? There is no date involved in this field, and I see only formats that involve date.

You can override the From/To format to convert the time accordingly by simply using the mapping option. Please check out the following screenshot for your better understanding.

I hope this might help you out.

 

[wibbler]

That's great, thank you! Not sure that "map" is the correct word for what this function does (maybe "custom" would be better?) but that has solved my problem.