Date/Time Duration Calcuation

[nightdesigns]

I have 4 fields, Date sent, Time sent, Date Received, Time Received. How can I find out the difference (duration) from Received and Sent?

Thanks.

[andygaunt]

Create a new calculation field with a result of time

((Date Sent - Date Received) * 86400) + Time Sent - Time Received

HTH

[nightdesigns]

I don't know what the heck happened, but I did as you told me and now that file crashes FM each time I open it!

FM5

Win2k