DATETIME_FORMAT conversions - minutes to hours (Concatenate)

Topic Labels: Formulas
488 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Hello Dear Community!

I am having not much fun concatenating minutes into hours.


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?


When I tried inserting:

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

Airtable got upset.

How do I do it, guys?

0 Replies 0