Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to add minutes and a number together?

Topic Labels: Formulas
Solved
Jump to Solution
1158 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Andrey_Lyovushk
6 - Interface Innovator
6 - Interface Innovator

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
ScottWorld
18 - Pluto
18 - Pluto

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
ScottWorld
18 - Pluto
18 - Pluto

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: