**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

How about those?

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