How to add minutes and a number together?

[Andrey_Lyovushk]

There are 2 fields: the time of the last modification of the line and just a number.
(last_modified_time and time)

How do I create a formula for the “result” field to add the minutes from the last_modified_time field and the number from the “time” field?
That is, the example should get: 38 + 100 = 138
(the field “result” should be 138)
(101 is there for an example, do not pay attention. Instead it should be 138)

[ScottWorld · Accepted solution]

First, change your “time” field to be a number field instead of a text field.

Then, use this formula:

MINUTE({last_modified_time}) + time

You can also reference the list of date & time functions on this page for other formulas that you might want to create:

Airtable - Support

Formula field reference

For an overview of formula fields, please refer to the Guide to Formula, Lookup, Count, and Rollup fields. Formulas may involve functions, numeric operations, logical operations, and text operation...