Ability to add hours, minutes, days etc to a date

[Offbase]

Right now the documentation says only days can be added to a date. Would love the ability to additional types of calculations.

[Offbase]

Duh…divide hours by 24 etc…

[darragh]

I actually answered a similar question here with a good explanation on how to do this with hours, minutes, seconds.

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 [image] The formula look like this: [image] 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…

One thing to remember is that Noloco formulas are based ofd excel-like formulas, so most basic things you can do in excel, you can do in Noloco