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