Help

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

DATETIME_FORMAT conversions - minutes to hours (Concatenate)

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

Hello Dear Community!

I am having not much fun concatenating minutes into hours.

image

In the image, where it says (for example) 75.16 minutes in line 4, I would like it to say 01:15 (or even 01h:15m.

My formula is below. I know it’s something to do with DATETIME_FORMAT, but what do I put in and where?

image

When I tried inserting:

& DATETIME_FORMAT({TOTAL Bearbeitungszeit}, 'h:mm')

Airtable got upset.

How do I do it, guys?

0 Replies 0