Hi!
Is there any possibility to make a time column type? I’m working in Grist with transit timetables in which date is irrelevan and need of filling it is a bit frustrating. I would welcome the possibility to turn off date component in DateTime type.
Thank you in advance!
It’s a valid feature request, but no plans for it yet. Here are some related requests – these also include some workarounds that you may fine helpful:
Hi ! I’m new to Grist and i’d like to use it for storing and compiling our brewing day sheets.
I’ve made several views from a table, action buttons to fill datetime fields with a now() function. It works very well and allows me to calculate timespans by substracting a start time from an end time, very cool.
However, i have no interest in using the date part of the field and it clutters my views with useless information. Is there a way to end up with a time only field ?
opened 04:16PM - 12 Aug 24 UTC
### Describe the problem to be solved
Grist only allows dates and datetimes f… or date/time related information. This would be unable to handle things like a recurring event happening at some specific time of day, where the date information is not relevant. Attempting to emulate this with datetimes is unsatisfactory currently as it is impossible to hide the date information for a datetime column.
A time data type is also standard in all major databases, and both Excel and Google Sheets easily display times without a day.
#1071 only requests for a duration column type, which is the difference between 2 datetimes, while this request is for a time column type, representing a specific time of day.
### Describe the solution you would like
Implement a time column type. Python already has a `time` object available in the standard library, so maybe that could help with simplifying some implementation.