Skip to main content

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?

Be the first to reply!

Reply