Calculating The Length Of a Call Time

S

Sheria

Hi, Does anyone know how would I go about calculating the Length of a call
time. I wanted to start with a Start Time and a End Time. For example, if a
Rep. receives an incoming or out going call at 9:38am and the call ended at
9:45am after all the clients information have been entered into the system
and once the Rep exit the screen the time can automatically set it self.
Would anyone have a idea of how this would work. I tried the =Now() and the
time is the same for the start time and the end time.

Thank you
Sheria
 
R

Rick B

Well, =Now() puts in the current date/time. If you use code to place "now"
in the start field when you open the form, and if you use "now" to set the
curent time in the end field when you close the form, you should be good.

The key is that you have to tell it WHEN to put the time in the field.

You say that you have the same time in both, how are you getting it there?
You must have one single event setting both fields. You can't do that. The
two items happen at different times (events). One when you open the form,
and one when you close it.
 
S

Sheria

Ok, Thank you

I have 2 different fields one that just states the time and another for the
length of call for how long the call has lasted while in the form.
 
Top