Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to add minutes and a number together?

Topic Labels: Formulas
Solved
Jump to Solution
475 1
cancel
Showing results for 
Search instead for 
Did you mean: 

There are 2 fields: the time of the last modification of the line and just a number.
(last_modified_time and time)
Screenshot_1
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)

1 Solution

Accepted Solutions

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:

See Solution in Thread

1 Reply 1

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: