Working with time

Hey @rjp this can be done using a formula field

In this example, I’m using a formula field Created At + Duration to add the Duration field to the Date Time in created at

The formula look like this:

TODATE( {created at}  + TIME(0, 0, {Duration} ) )

There’s 3 parts to this.
Firstly, all Noloco formulas work the same way they do in Excel, so typically you can search for similar solutions in excel.

To add time to a date time in excel, you simply add the time in minutes.

Do 12/02/2024 + 90 would be 12/02/2024 01:30

So we can do the same, but we first need to convert the duration (which is stored in seconds) to minutes, or a time field for even more convenience.

TIME(0, 0, {Duration} )

This passes the Duration field into the seconds argument of the TIME function.

{created at} + TIME(0, 0, {Duration} )

This then adds that time to the created at Date Time.

Finally, you need to convert that date value back to a Noloco Date
This is mentioned in our guides on using Dates in Formulas

TODATE( {created at}  + TIME(0, 0, {Duration} ) )

You can replace created at and Duration with your own fields