I work with specific events that have time values but not date values. It would be really nice if I could have a time attribute alone, or be able to turn off the date attribute in the time/date
I was just looking for this the other day!
I found this feature request: Another Date Request: Date Ranges
But I, like you, would like to have a dedicated attribute for “Duration,” which is available in airtable and a field I regularly used.
Another, maybe easier to develop solution, could be for the Infinity team to add another option to the dropdown for different “number” attribute types: Integer, Decimal, Percentage, Currency, and Custom.
I’m currently using “Decimal” with “.00” two decimals for minutes in some columns and in others, I measure hours by putting hours and rounding minutes as follows:
.25 ➞ 15 mins
.50 ➞ 30 mins
.75 ➞ 45 mins
This is not ideal. I would like to have one column representing “Duration” and allowing me to measure hours and minutes as 00:00.
Mine is more a “start time” and “end time” with no associated date, which then I usually do a calculation on to determine duration ( or “start time” plus duration equals “end time”).
I have also implemented a decimal solution for the time being, but it creates another step for me at the end. Not huge, but it would be nice it I could have the value in Hours and Minutes and AM & PM.