2 Replies Latest reply on Jun 24, 2010 1:00 PM by FM9NewUser

    Elapsed Time Calculation

    FM9NewUser

      Title

      Elapsed Time Calculation

      Post

      Hi!

       

      I am a fairly new user to FM 9 and am having issues with calculating elapsed time.

       

      I have 4 fields:  Referral Date; Referral Time, Pickup Date; Pickup Time. All fields are set up as Date or Time fields.  To find the time between the referral and pickup, I tried the following that I found on an earlier posting:

       

      Timestamp (Pickup Date; Pickup Time) - Timestamp (Referral Date; Referral Time)

       

      All I get is "?".  Can someone please tell me what I am doing wrong?  BTW, the time can be greater than 24 hours.

       

      Thank you in advance for your help!