AnsweredAssumed Answered

Elapsed Time Calculation

Question asked by FM9NewUser on Jun 24, 2010
Latest reply on Jun 24, 2010 by 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!

Outcomes