As many know, Appsheet do not have support for 24Hr formats. In the forum there are many work arounds, like using CONCATENATE() or some variation of TEXT(TIME([Date Time Entered]),“HH:MM”). These aren’t very streamline solutions and may involve multiple columns to implement.
Here is my workaround that allows users to input in 24HR format and also display in 24HR using just one single column.
First input a column of Type Number,
Under Type Details, make sure the following settings are inputted.
Numeric Digits - 4
Show thousands separator - Unchecked
Maximum Value - 2359
Minimum Value - 0
Increase/decrease step - 1
Next, under Data Validity > Valid If
Input the following formula. This formula ensures that the column only excepts up to 23 for hours and 59 for minutes.
IF( [FP Start Time] <= 959,
NUMBER(LEFT([FP Start Time],1)) <= 9,
NUMBER(LEFT([FP Start Time],2)) <= 23
NUMBER(RIGHT([FP Start Time],2)) <= 59
Lastly, under Auto Compute > Initial Value
You may choose to input this optional formula. This formula will input the current time when you start the form in 24HR format. It may be a good indicator for first time users who are unfamiliar with what time format is accepted in the field.