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.
