How to add time to a Date Time field

Formulas
1

Hi there. I have a Date Time field and a number field containing durations in minutes. How can I create a formula, which would add the duration to the Date Time field ?

Exemple:
DateTime field = 2024-09-06 18:00
Duration = 120
Formula = 2024-09-06 20:00

It would be very easy to do in Excel but I cannot find a way in NocoDB.

Many thanks for your help

2

The smallest granularity that “DATEADD” supports is in days. One hack that you can use for this case will be to convert Duration in “days” and add DATEADD formula.

The following works
DATEADD({DateTimeField}, ({Duration} / 1440), "day")