Tricky Qs. Ms Excel

[Aamir]

How can i set the number value after . (DOT/Point) to less than 10. B
default Ms Excel works in base 10, how can i set to count in base 7 (m
own requirements).

e.g

There are two bowlers A & B, A bowls 4.3 Overs & B bowls 2.4 Overs an
in each over there are six balls he can bowl maximum.
When i add total overs

4.3 + 2.4 = 6.6 in excel but i want 4.3 + 2.4 = 7.1
(As .3 + .4 is equal to 1 Over + 1 Ball)

Got it or Not?

 

[Gordon]

How can i set the number value after . (DOT/Point) to less than 10. By
default Ms Excel works in base 10, how can i set to count in base 7 (my
own requirements).

e.g

There are two bowlers A & B, A bowls 4.3 Overs & B bowls 2.4 Overs and
in each over there are six balls he can bowl maximum.
When i add total overs

4.3 + 2.4 = 6.6 in excel but i want 4.3 + 2.4 = 7.1
(As .3 + .4 is equal to 1 Over + 1 Ball)

Got it or Not??

I think you would be better posting in a dedicated Excel group rather than a
general Office one.

news://msnews.microsoft.com/microsoft.public.excel.newusers

 

[Aamir]

this works but not look good

A1= value1
A2= value2

For complete overs

=INT(((INT(A1)*6)+((A1-INT(A1))*10)+((INT(A2)*6)+((A2-INT(A2))*10)))/6)

=(((INT(A1)*6)+((A1-INT(A1))*10)+((INT(A2)*6)+((A2-INT(A2))*10)))/6-INT(((INT(A1)*6)+((A1-INT(A1))*10)+((INT(A2)*6)+((A2-INT(A2))*10)))/6))*6

If some 1 wants to try just copy and paste into A3 & A4 cell
respectively
but still problem is answer is not in one cell..!!

any other idea or want to improve above..

 

[Bob I]

You will need to use the MOD function as part of your solution.