ExcelBanter - Average of time

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Average of time (https://www.excelbanter.com/new-users-excel/269954-average-time.html)

RSM42

Average of time

Hi,

Within Excel 2007, 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.

Help ????

nagendraprasad.v

3 Attachment(s)

Quote:

Originally Posted by RSM42 (Post 964249)

Hi,

we have to use the delimit option to split the data and we approach the average function.

martincrow

Quote:

Originally Posted by nagendraprasad.v (Post 964295)

Hi,

we have to use the delimit option to split the data and we approach the average function.

Thanks for the screen shot you posted here, it is really helpful in explaining most of the things.

All times are GMT +1. The time now is 05:02 AM.