Convert time to 24 hour format

Does anyone have a dependable 24 hour format expression you’d be willing to share? Trying to convert this as an example:


A million thank you’s!

Hi @Daisy_Ramirez,

I believe you may wish to mention some more details. Is this 12 hour format date captured in a spreadshet? Do you wish to capture 24 hr format only in spreadsheet or are you looking for 24 hour format to be displayed in specific views of the app?

Thanks Suvrutt,

I’m looking to have the 24 hr formatted date generate in a .csv file so my guess is it would have to display the 24 hour format in appsheet? The .csv seems to reflect other data adjustments I’ve made with the appsheet table.

Thank you @Daisy_Ramirez.

Please explore if following workaround created based assuming Googlesheet as back end helps.

Please create a column with Google sheet formula of converting AM/PM time into 24 hrs format and then as a text. The column (Time24Text) and the correspnding Google sheet expression are highlighted in green. The column Time24Text is with spreadsheet formula and type as Text in the app. It converts the 12 hr time from adjecant column Time into 24 hr format.


The images below shows the table view in the app and then downloaded CSV.

Table :


24hr%20CSV !


Got it. I’ll report back shortly. Thanks so much Suvrutt!

1 Like

Hi, @Suvrutt_Gurjar,
How to make the user enter time in 24 format?!

Hi @Kanha_PM_Office,

Here is my understanding. I am sure there will be more insights from the community. I am unsure on how to compel the user to enter the time in 24 hour format especially a time after 12 PM. Once a field is user enterable ,I believe there may not be options to ensure the user enters only desired value, as long as it is a valid value. Indirect ways could be typically where we wish the user to follow certain pattern , we could use initial values from system or use actions to set the values so that user goes on the anticipated pattern.

Also in device( mobile ,tablet, desktop), if the device time setting is set to 24 hrs format , the user is most likely to follow that format as he gets presented with those specific formats when changing the field. However still if the user needs to enter 18:00:00 for 6PM and he enters 06:00:00 , even in 24 hour format, I am unaware how it can be prevented.


You cannot if the column type is Time or DateTime.


Any other option as Text?

You’d have to manually validate the user’s input, and the user wouldn’t have the convenience of the time picker.

Why do you want to force 24-hour format?

To avoid errors in AM / PM selection. They shall easily select the time if it’s 24 hour format.

Yes @Suvrutt_Gurjar, this is exactly the problem which we are facing.!!

Thanks Suvrutt, this worked but I’ll post another expression within AppSheet I’ve had some success with.

Thanks for your help!

Below is an expression I’ve had success with for the 24 hour Format:

TEXT(TIME([Date Time Entered]),“HH:MM”)

1 Like

Hi @Daisy_Ramirez

Thank you for posting a compact expression.

Just wanted to mention, the reason I suggested Google sheet based approach. These very useful TEXT() expressions for managing date/time that you used were added by the AppSheet team about two weeks after we discussed Google sheet in this thread.

I agree with you that these are indeed very useful ,compact expressions for handling datetime.

1 Like

Awesome! I missed this post - I thought I was brilliant! :slight_smile: :laughing: