AnsweredAssumed Answered

Calculate elapsed time

Question asked by rakeshkatipalli on Aug 18, 2014
Latest reply on Aug 18, 2014 by philmodjunk


Calculate elapsed time


     Hi everyone.

     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