circket overs

[itachimsi]

i have problem,how to convert balls in overs.
for e.g: 6 balls = 1 over
when i enter 7th ball, over didn't change to 1.1
plz give some solutin

 

[JackDanIce]

Welcome to the board, see this link: http://www.mrexcel.com/forum/excel-questions/647014-cricket-overs.html

 

[FormR]

Another possible option (if I have understood correctly)

Excel Workbook
	A	B
1	Balls	Overs
2	1	0.1
3	2	0.2
4	3	0.3
5	4	0.4
6	5	0.5
7	6	1
8	7	1.1
9	8	1.2
10	9	1.3
Sheet1

 

[itachimsi]

thank u so much...this is really i want...thannnxxxx

 

[FormR]

cricket over was not helpful,give me some solutiom plz

See post#3 is that what you are looking for?

 

[itachimsi]

yeah that was helpful