Is there a way to enter a Time column without...

(Stephen Mattison) #1

Is there a way to enter a Time column without the AM/PM?

I need only the HH:MM:SS for timing purposes, no AM/PM necessary.

Need super fast data entry. TYVM!

(Tony Fader) #2

@Stephen_Mattison Not right now. One workaround would be to break your time up into three number fields (hour, minute, second) and then combine them into a time using an app formula.

(Aleksi Alkio) #3

@Stephen_Mattison You need to change the country so you could have different time format :slight_smile:

(Stephen Mattison) #4


Thanks! I have it set up like that now, with three Enum columns as Buttons for [HH], [MM], [SS] and CONCATENATE into [Time] column.

I added an Editable_If of =ISBLANK() on HH, MM, SS columns to speed up data entry and keep user from bumping the wrong number Button as they scroll down.

it goes pretty fast, but there’s lots of scrolling to choose [MM] & [SS].

An HH:MM:SS column option without AM/PM would be great for many timing Apps, would eliminate three columns, it would be much better UI and probably even faster data entry, and I wouldn’t need the ISBLANK Show_if, so it would be easier to make corrections before clicking Save.


(Stephen Mattison) #5

@Aleksi_Alkio I’ll look into changing country, thank you!

(Stephen Mattison) #6

@tony Oops! Originally in my Comment/response to you above I said that I added a Show_if, but I meant Editable_if, sorry for the confusion, I corrected my comment.

(Aleksi Alkio) #7

First… where do you need seconds? Another question is… could it be better to use 4 columns from 0…9. Now you have minutes and you need numbers from 00…60. Then you could use buttons and probably no need for Show_If.

(Aleksi Alkio) #8

And… Can you use initial value or do they need to fill everything manually?