Time measurement

[srburk]

I am tracking the time (in minutes) that an employee spends on the telephone.

The employee tracks the following numbers:
CB1 - Call 1 begins: 12:01 pm
CE1 - Call 1 ends: 12:05 pm
CB2 - Call 2 begins: 12:08 pm
CE2 - Call 2 ends: 12:32 pm
CB3 - Call 3 begins: 12:32 pm
CE3 - Call 3 ends: 01:00 pm

I would like to calculate the number of minutes spent ON the phone.
I would also like to calculate the number of minutes spent OFF the phone.

Using only three call, I can determine the length of each call by typing:
totalcall1: DateDiff("n",[CB1],[CE1])

I can also determine the length of time in between calls:
durbetween1and2: DateDiff("n",[CE1],[CB2])

My question:
How do I add up the individual calculations:
totalcall1 + totalcall2 + totalcall3
durbetween1and2 + durbetween2and3 + durbetween3and4

What if (as listed above) the employee hangs up at 12:32pm and then picks up the phone again at 12:32 for the next call... how do you count the total duration of all calls without counting 12:32 twice.

Thanks for any help!!!
Scott

 

[FLabrecque]

To answer some of your questions... I would seriously think to calculate the seconds. Minute, is just isn't enough. This way, if he hangs up at 12h31:12 but picks up at 12h31:45, you will have the precision needed.