# Excel - AVERAGE Function Problem - Expert Solution

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

I need help calculating average time elapsed. It is in dd:hh:mm:ss text format and so I can't calculate using =AVERAGEIF
Solved by O. E. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 17/05/2018 - 04:54
Hi VT
Excelchat Expert 17/05/2018 - 04:54
Hi
User 17/05/2018 - 04:54
I'm trying to get an average time based on an averageifs formula
Excelchat Expert 17/05/2018 - 04:54
Ok
User 17/05/2018 - 04:54
problem is that I think the time data is in text format?
User 17/05/2018 - 04:54
and so it won't average?
User 17/05/2018 - 04:54
I'm getting a Div/0 error
Excelchat Expert 17/05/2018 - 04:54
Please let me know how you want to take the average
User 17/05/2018 - 04:55
So if column D is A, I want it included
User 17/05/2018 - 04:56
see how I cant even average these?
User 17/05/2018 - 04:56
THink its the format
Excelchat Expert 17/05/2018 - 04:56
Ok
Excelchat Expert 17/05/2018 - 04:56
Please allow me couple of minute
Excelchat Expert 17/05/2018 - 05:02
I see
Excelchat Expert 17/05/2018 - 05:02
so, once you can convert all the text into real time
Excelchat Expert 17/05/2018 - 05:02
Then it should works
User 17/05/2018 - 05:03
right so they arent time
User 17/05/2018 - 05:03
its time elapsed
User 17/05/2018 - 05:03
between to times
User 17/05/2018 - 05:03
so 7 hours elapsed
Excelchat Expert 17/05/2018 - 05:04
ok
Excelchat Expert 17/05/2018 - 05:04
so, in G16 it gives the answer
User 17/05/2018 - 05:05
great!
User 17/05/2018 - 05:05
thank you!
Excelchat Expert 17/05/2018 - 05:05
You are welcome

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.