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