Calculate elapsed time
I am very new to FMP. I want to calculate the elapsed time between current timestamp and ticket creation date, ticket creation time (provides manually) in days, hours and minutes.
I have two fields
1.ticket creation date
2. ticket creation time.
with the help of these two fields i have to calculate the elapsed time.
the output should be like: 2 days, 4 hours and 30 minutes.
Please provide steps clearly.
Thanks in advance
The first step is to compute the elapsed time in seconds. From there, you can compute days, hours and minutes.
Get ( CurrentTimeStamp ) - TimeStamp ( CreationDate ; CreationTime )
will get you the elapsed time in seconds. From there, you can use the number of seconds in a day, hour and minute to compute the elapsed time in the format that you specify.