time keeping for multiple entries

L

Lane

I have a sheet in which 45 entries represent calls in a call center.
I want each call to be timed, and averaged as they accumulate.
My goal is to track how long each transaction takes and average cal
times. I would like this to happen without the user having to monito
it, but it will happen as they enter text into cells.

the first cell (or start timer) is b2, end timer is d1. This patter
will carry out for 45 entries.

Most of the vba stuff I've seen posted does not deal with odd multipl
entries. What can I do?

Thanks Everyone....Lan
 
F

Frank Kabel

Hi
not quite sure how your pattern continues? (B3 and D2)? You may post
some example data (plain text - no attachment please) and describe your
expected result for this example
 
F

Frank Kabel

Hi
to get the sum of your times you may use the following array formula
(entered with CTRL+sHIFT+ENTER)
=SUM(D1:D45-B2:B46)

to get the average divide this sum by 45
 
L

Lane

Actually, the averaging I can handle....It's the timer that I am havin
trouble with. How do I do the timer?

Thanks again!
Lan
 
F

Frank Kabel

Hi
what do you mean with timer=
maybe
=D1-B2
and format the resulting cell as time??
 
L

Lane

When I put a name into cell b2, i want d1 to show the time that wa
entered. When I put a text entry into d2, I want f1 to show that time
and so forth.


Does that Help?

Lan
 
Top