Just curious on people’s use cases for this. A time by itself doesn’t constitute a datetime value. If there was a time-only picker, what would people expect to see for the value stored in the sheet? Would it it just be a value like ‘12:00’ PM or would it be the decimal equivalent like ‘0.5’. The only reason I ask is because as it stands now, ‘12:00’ could only be handled as a text value and you wouldn’t be able to do any date math against it, unless it’s accompanied with a default date (such as epoch 01/01/1970 or today’s date. In the decimal form, like ‘0.5’, you can then use it to perform date math against a date.
Technically you could create a choice list of pre-set times and their underlying decimal equivalent, then add the decimal value to a default date, such as today 0:00 (12:00 am). The only downside is that you would need a pre-set list and would probably be restricted to certain blocks of time, like every 5 or 15 minutes, so a native time-only picker would make sense because you could pick any hour or minute of the day.
I guess in my opinion, for a time picker to be viable, it would either need an accompanying Time Only column type that can store the decimal equivalent of time, while having a formatting option (like the date column does) to show a friendly formatted time…or, it could save into an existing date column, but with a default date, such as epoch 01/01/1970 or Today.
A full date/time format or decimal equivalent would still allow you to perform date math, while a text string of only time (12:00) wouldn’t allow you to do much other than display it in a text component.
You could get a little tricky and create a template column that joins text and time together to get something like ‘Today at 12:00pm’ or ‘Tomorrow at 12:00pm’ and write that text to a date column, which will translate it into a date/time, but it will be a dynamically changing date, and I think that leads to a lot of workarounds that many people wouldn’t understand.
Edit: As I think about it, you could technically write a time only to a date column and it will pick today as a default date, but I still think that while the time will be static, the date might actually still be dynamic and change daily.
I’m just trying to understand how people would expect a time picker to work, how they would expect the value to be stored, and how they would intend to work with the resulting value
