Julie has attended:
Excel Intermediate course
Time Averages
how do you calculate time averages e.g
12:00
01:00
00:30
00:30
00:40
00:45
07:00
add and find average
RE: Time Averages
Hi Julie
Thank you for your question.
Normally Excel stores dates as values, so theoretically the average function should work on this: =average(cell range)
I tried copying and pasting your times into a spreadsheet and using the average function and it gave me 03:12 as the average time, which sounds about right.
I hope this answers your question.
Amanda