# Excel - AVERAGE Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need an average of a non contiguous cells of times.
Solved by E. A. in 17 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 08/08/2018 - 07:13
Hello！
User 08/08/2018 - 07:13
Good afternoon!
Excelchat Expert 08/08/2018 - 07:13
Welcome to got it pro!
User 08/08/2018 - 07:13
thank you!
User 08/08/2018 - 07:13
Hopefully you can help
User 08/08/2018 - 07:14
can i paste in this excel sheet?
Excelchat Expert 08/08/2018 - 07:14
I saw you have a question regarding use average funciton
Excelchat Expert 08/08/2018 - 07:14
Sure
User 08/08/2018 - 07:14
thanks
Excelchat Expert 08/08/2018 - 07:14
You can just provide sample as well
User 08/08/2018 - 07:14
I need an average of just the run times here
User 08/08/2018 - 07:15
In the excel sheet im working on I can't separate the word run from the times..
User 08/08/2018 - 07:15
weird that it pasted separately hee
User 08/08/2018 - 07:15
here
Excelchat Expert 08/08/2018 - 07:16
Ok
User 08/08/2018 - 07:16
No idea how to go about doing this
Excelchat Expert 08/08/2018 - 07:16
so, you need average of column B?
User 08/08/2018 - 07:16
correct
Excelchat Expert 08/08/2018 - 07:17
Please make sure column B only involve with time
Excelchat Expert 08/08/2018 - 07:17
then I can do the average for you
Excelchat Expert 08/08/2018 - 07:17
For some columns it shows as date as well
Excelchat Expert 08/08/2018 - 07:17
That will cause certain issues
Excelchat Expert 08/08/2018 - 07:17
Overall, you will need to use average() function to calculate it
User 08/08/2018 - 07:18
Thats part of the problem Im having, how can i get rid of those unwanted sections?
Excelchat Expert 08/08/2018 - 07:19
Please click on the filter the de-select all year realted rows
User 08/08/2018 - 07:19
there we go the dates are gone
Excelchat Expert 08/08/2018 - 07:20
Ok
Excelchat Expert 08/08/2018 - 07:20
Then the average function in D1 is works!
Excelchat Expert 08/08/2018 - 07:20
:-)
User 08/08/2018 - 07:20
These are run times, like 18 minutes and 49 seconds
Excelchat Expert 08/08/2018 - 07:21
ok
User 08/08/2018 - 07:21
so i guess the average of those times is 19:20
User 08/08/2018 - 07:21
?
Excelchat Expert 08/08/2018 - 07:21
yes
Excelchat Expert 08/08/2018 - 07:21
Now it works
Excelchat Expert 08/08/2018 - 07:21
:-)
User 08/08/2018 - 07:21
thank you!
User 08/08/2018 - 07:21
I actually have two more sets
User 08/08/2018 - 07:21
can i send them to you?
User 08/08/2018 - 07:25
User 08/08/2018 - 07:25
in column F
Excelchat Expert 08/08/2018 - 07:25
Well, you can do the same thing here
User 08/08/2018 - 07:25
right can you teach me that function? whenever i use =average on my side it wont work
Excelchat Expert 08/08/2018 - 07:25
But you can keep them in seperate columns
Excelchat Expert 08/08/2018 - 07:25
average()
Excelchat Expert 08/08/2018 - 07:26
in the parathesis, please include the range you need
User 08/08/2018 - 07:27
awesome thank you
User 08/08/2018 - 07:27
not sure why this is working better here
User 08/08/2018 - 07:27
but im going to copy my last set here then get out of your hair
Excelchat Expert 08/08/2018 - 07:27
Well, sometimes it happens
Excelchat Expert 08/08/2018 - 07:27
:-)
Excelchat Expert 08/08/2018 - 07:28
Hope you have a wonderful day
User 08/08/2018 - 07:28
you too!!
Excelchat Expert 08/08/2018 - 07:28
And please feel free to leave me some positive feedback
Excelchat Expert 08/08/2018 - 07:28
Welcome to got it pro!

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.