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!
@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.
@Stephen_Mattison You need to change the country so you could have different time format
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.
TYTY!
@Aleksi_Alkio I’ll look into changing country, thank you!
@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.
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.
And… Can you use initial value or do they need to fill everything manually?
User | Count |
---|---|
18 | |
10 | |
8 | |
5 | |
5 |