How to calculate the average time in excel

[Rao's]

Within Excel, I need to calculate the average of the following time values in days, hours, minutes and seconds :

00:18:09:26
00:05: 34:50
00:07:41:06
01:22:52:55
00:00:55:48

I've tried using =AVERAGE(A1:A5) and changing the format of the values to various settings, but keep getting DIV/O as the result. So if you guys have any idea then please do the reply.

[Go!pee]

According to my information, you must try to make the use of the delimit option to split the data and you can approach the average function. May be this will help you out.