Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to format time in a lookup array of durations?

Topic Labels: Formulas
97 0
Showing results for 
Search instead for 
Did you mean: 

Hey there, I’m looking up a duration formatted formula field from multiple records. The result of the lookup looks like this “4:24, 6:00, 6:31”.

Is there a way to reference and DATETIME_FORMAT this in a formula field and get a similar output format? I cannot figure it out and get a zero value or the underlying seconds.

0 Replies 0