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.