time keeping for multiple entries

[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

 

[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

 

[Lane]

the pattern would be start b2, end d1, start d2, end f1, start f2, en
h1, etc....

 

[Frank Kabel]

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

to get the average divide this sum by 45

 

[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

 

[Frank Kabel]

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

 

[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

 

[Frank Kabel]

Hi
for this you need VBA. Have a look at the following site for creating
such timestamps:
http://www.mcgimpsey.com/excel/timestamp.html