Averaging time...

S

Shhhh

Hello all...

I have data from 6 separate events.... event A was finished at 9:05
74.05% of the time... each event is listed that way...So my data looks
like this...

A 9:05 74.05%
B 10:55 72.91%
C 14:05 72.47%
D 9:15 67.97%
E 14:05 69.40%
F 13:20 70.26%

Now what I want to do is weigh each time and figure out what the
overall average time would be? How do I go about doing that?

Thank you all.
 
B

Bob Phillips

Is it not just

=AVERAGE(C1:C6)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
B

Bob I

If you mean you are looking for the Average cumulative time of A through
F then Sum the times and average the percents.
 
Top