How do I calculate "weighted average" for times in an excel column?

Let me start over with the correct data--now how do I find avg weight for ASA

The weighted average is computed by dividing the sum of the weighted values by the sum of the weights. The SUMPRODUCT function will compute the numerator and the SUM function will compute the denominator. For example SUMPRODUCT(A1:A2,B1:B12)/SUM(B1:B12)

These are the corresponding calls handled for each time interval avg speed of answer (ASA)

Hi,

Weigh them by what? A simple average function seems to work

=AVERAGE(B2:B13)

Hi @Carrie Ward,

Good day to you! Welcome to Microsoft Q&A. 

Regarding to your description, here's how to do it step-by-step: 

1. Ensure Time Format 

• Make sure all cells in column A are formatted as Time (e.g., hh:mm or hh:mm:ss). 
• To check or change the format:  Right-click the cell → Format Cells → Time → Select appropriate format. 

2. Convert Time to Seconds (Optional for Intermediate Calculation) 

• In column B, use the following formula to convert time to seconds: =A1*86400 
• Drag this formula down for all rows (e.g., B1:B12). 

3. Calculate Average Time 

• If you want the average time directly in time format: =TEXT(AVERAGE(A1:A12), "hh:mm:ss") 
• This will return the average in a readable time format. 

4. Alternative: Average in Seconds 

• If you prefer to see the average in total seconds: =AVERAGE(A1:A12)*86400 

5. Display in a Single Cell 

• You can place the formula from step 3 or 4 in any cell (e.g., A13) to show the result at the bottom of your column. 

This is the final result applying the above steps:  

If you have any further questions and concerns, please don’t hesitate to ask. Looking forward to your response. 

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.