1 Reply Latest reply on Aug 18, 2014 7:21 AM by philmodjunk

    Calculate elapsed time

    rakeshkatipalli

      Title

      Calculate elapsed time

      Post

           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

        • 1. Re: Calculate elapsed time
          philmodjunk

               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.