Hi,

these 2 work fine for me

Column A - average of the times
=AVERAGE(A2:A5)

Column B average of the percentages

=AVERAGE(B2:B5)

A good tip is always pot your formula even if you know it's wrong.

Mike


"Sathisc" wrote:


Thanks guys its working perfect,

When i average the 100% for all the days the average is not working.

A B

10:40 100
11:12 100
11:02 100
10:00 100
11:14 100

10:49 #DIV/0!

In A7 i have averaged the time and in B7 i couldnt able to average all
the b column.

can you help in this.


--
Sathisc
------------------------------------------------------------------------
Sathisc's Profile: http://www.thecodecage.com/forumz/member.php?userid=187
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=77749