Date or datetime field are cool, but time only field would rock

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 ?

A workaround I have used (which helps at least with the “clutters my views” part of your post) is to set a custom format on the date part and type in a single blank there.

(You can’t use an empty string; that defaults to yyyy-mm-dd or so).

1 Like

Thanks for the advice ! It works indeed to unclutter views.

But since the date part of the field is still there it makes time calculations a bit clunky : I have to use something like HOUR($datetime_field)*60+MINUTE($datetime_field) to get a duration, which seems kind of silly. Another downside is when manually editing such a field, date appears and can be edited, although it’s still not used.

Maybe there’s a way to work with time that i missed though !