Averaging time...

[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.

 

[DILipandey]

Hi, one approach would be taking the sum product of time and percentages.
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India

 

[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)

 

[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.