# How to Calculate Average Time in Excel

To calculate the average time in Excel, you can use the AVERAGE function. The AVERAGE function calculates the average (arithmetic mean) of a range of cells containing numbers, including time values. Here's how to calculate the average time in Excel using the AVERAGE function:

- Enter the time values in a range of cells: You can enter time values directly into cells using the hh:mm:ss format or use the TIME function to create time values.
- Click on an empty cell where you want the average time to be displayed.
- Type the AVERAGE function formula:
`=AVERAGE(range)`

, where "range" refers to the range of cells containing the time values you want to average. For example, if your time values are in cells A1:A5, the formula would be`=AVERAGE(A1:A5)`

. - Press Enter to display the average time in the selected cell.
- If necessary, format the result as time: If the result is not displayed as a time value (e.g., it appears as a decimal), you may need to apply a time format to the cell. To do this, right-click on the cell, select "Format Cells," choose the "Time" category, and select a time format.

## Example

Let's say you want to calculate the average time spent on a task by five employees. The time values are entered in cells A1:A5 as follows:

```
A1: 00:35:00
A2: 00:45:00
A3: 00:42:00
A4: 00:55:00
A5: 00:48:00
```

To calculate the average time:

- Click on an empty cell where you want the average time to be displayed, for example, A7.
- Type the AVERAGE function formula:
`=AVERAGE(A1:A5)`

. - Press Enter to display the average time in cell A7. In this case, the result is
`00:47:00`

. - If necessary, format the result as time by following the steps mentioned earlier.

Did you find this useful?