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