We have a call tracking lotus notes application that records incoming calls from the public.
Currently we are using Lotus Notes 6.5.5 but will be upgrading to Lotus Notes 8.5.1
On the form we have a date / time field called FTR_CreatedOn which records the creation time of the call tracking document ie @Created e.g. 06/12/2013 11:30:45 AM PDT.
When the clerk finishes recording a call, he or she clicks the Save and Close button on the form and the document is closed out. What we want to do is have another date/ time field computed on the form (I will call it EndTimeofCall) at that moment of the save and close that records the end of the call e.g. 06/12/2013 11:34:17 AM PDT.
We will then have another field on the form that computes the difference between these two date time fields called CTElapsedTime in seconds:
CTElapsedTime:= EndTimeofCall - FTRCreatedOn
My question is what formula should I use for the EndTimeofCall. I am a bit stuck and could use some advice.
Thank you for any and all help.
John Falloon