Create Function fro adding Cricket Overs

Hi all,

i reaaly need some help creating a function that will add cricket overs.

overs are written as follows:

1.1, 5.5, 12.3

The first half of the number is actually a multiple of six and the second half can only reach 5 and represents one bowl.

so 2.3 overs is actually 15 bowls beacuse 2 * 6 = 12 and .3 = 3 so 12 + 3 = 15.

hope thats clear for the non-cricket amongst us.

anyway i need to create a function that will allow me to add over up.

problem being is i don't know how to get around the second part of the number as once it exceeds .5 it should then at another multiple of 6 then start again at 0.

i would like to be able to add upto say 20 values at any one time in the function if possible.

i have no idea how to set this one up so any help is much appreciated

thanks for reading all

Thans very very much mate

This Function works really well however:

my overs are not in one joined range e.g. (A1:A10)

they are more like A1, A4, A7 etc

is there an alteration i can make so that the function can be used as follows:

=AddOvers(A1,A4,A7......)

Hope that's clear and your help is greatly appreciated!!

ta