I built a base to track my medicine but need a time field type to improve it. Any chance that could be developed? You probably want to build in standard time where user can designate their time zone and what is known as military time.
Duration is a new [and, as of yet, undocumented] field type; when I go to reconfigure a field, ‘Duration’ is directly below ‘Date’ in the drop-down menu.
I don’t think it’s a beta offering; however, as @Shani_Taylor said in her letter, it’s currently supported only on web and desktop apps. (You should have gotten the same message. To check, from your Airtable home page [the base selection page], click the ‘?’ help icon and select ‘Contact support.’ In the ‘Contact Support’ window, select 'See your past conversations` on the left-hand side of the screen. If you did receive it, it will be in the list of ‘Conversations with Airtable.’ If you didn’t receive it, it pretty much says what I posted in my earlier reply.)
The Duration field type that @W_Vann_Hall mentioned is still in beta. You can sign up for early access to the duration field using our beta feature access form. Sorry for the confusion!
Oops, my apologies. I thought it might be Pro only, but I couldn’t find
anything that referred to it as beta. It’s freaking great, though. Kudos
and congratulations all around!
I signed up for the duration field beta feature via the link above. Is this something that airtable will have to approve for me to access or should it kick in automatically?
Could you add a field type for Time only? The data I am working with has a column for start time and one for end time, apart from the date. This would be immensely helpful. Thanks!
Also, FYI, my data disappears when I use the date or number format.
Hey everyone! Our latest field type, duration, just got released today. It’s designed to store time durations measured in hours, minutes, seconds, or milliseconds. There are five different formatting options, ranging from h:mm to h:mm:ss.sss. You can also now format the output of computed fields as durations, and use durations in formula fields. Check it out, and let us know what you think!
Hi, I have seen the new duration field feature, but I found that is less practical than a date field to create time tracker or time recorder. Which I suppose it was created for.
With date field with time you can easily create a time tracker:
StartTime column with Data field
EndTime column with Data Field
Length column with the next Formula:
IF( NOT( (DATETIME_DIFF({EndTime}, {StartTime}, ‘minutes’) / 60) > 0) , 0 , (DATETIME_DIFF({EndTime}, {StartTime}, ‘minutes’) / 60))
With this you can create probably the same than with duration field. But the most useful part of date field is that you can click on the cell and click on “Today” button to register the exact time you start or end, so this way you don’t need to type the time on the cell every time you want to register a new start/end time.
So I think that put a simple button which enter the actual time when you click, would be the minimum requirement to change to duration field. Because I can’t really see a big difference between data field and time field. Maybe are the seconds?
This is how I use it.
Would be really useful to have the button “Today” on the phone app.
