Count Elapsed Time from a specific timestamp

App Development
1

Hi all,

how to set an Equation to calculate the elapsed time in minutes from a specific timestamp?
I set this equation, but not sure how to convert the result (e.g. 120:15:10) to minutes?

TIMEDIFF({Date}, NOW())

2

This might work for you:

HOUR(TIMEDIFF({Date},NOW()))*60+MINUTE(TIMEDIFF({Date}, NOW()))

Keep in mind this based on when the record is saved/updated. Not “NOW” like when its being viewed. If you want the dynamic value check out this:

Or the Date Pipe.

2 Likes