Convert the 24-hour time format string value to the 12-hour format in ArcGIS Enterprise and ArcGIS Online Map Viewer

Summary

At times, it is necessary to convert the 24-hour time format string values to the 12-hour format (AM or PM). However, it is time-consuming if the data provided is large, as shown in the image below. This is resolved by using an Arcade expression to populate the data in the attribute table. This article provides the steps to convert the 24-hour time format string values to a 12-hour format using an Arcade expression in ArcGIS Enterprise and ArcGIS Online Map Viewer.

Procedure

Note:
This workflow only applies to time data in a text field. For time data in a date field, use the Convert Temporal Field (Data Management) tool in ArcGIS Pro to convert the date field to a text field.

1. Log in to the ArcGIS Enterprise portal or ArcGIS Online and click Content > My content.
2. Browse to and click the hosted feature layer to open the item page.
3. Click the Data tab to show the table.
4. Convert the time to the 12-hour format using an Arcade expression.
   1. Click the field header of the time field, and select Calculate from the drop-down list.
   2. For Select language, select Arcade and click Next.
   3. Copy and paste the following expression into the Arcade expression box. Replace <TIME_FIELD> with the name of the time field. Click Run.

var t = ($feature.<TIME_FIELD>)

var h = Number(Split(t, ":", 2)[0]);
var m = Split(t, ":", 2)[1];
var AMPM = When( 
h > 12, h - 12,
h == 0, 12,
h );
var suffix = When(
h == 24, " AM",
h >= 12, " PM",
" AM" );
Concatenate( [ AMPM, m ], ":" ) + suffix;

5. When the Output tab displays the time in the 12-hour format, click Run calculation.

The attribute table below shows the time in the 12-hour format.