Dividing function: can you define the decimal place?

[PhoebeB]

I am trying to divide the amount of days to return its equal amount o
weeks. For example, with 146 days, there are 20 weeks and 6 days. I
there a way to divide 146 to return 20.6, with the decimal being th
number of days left in that specific week? This is similar to
baseball/pitching statistic, if a pitcher pitches 5.2 innings (2 out
is the decimal place). To add a list of stats like that there needs t
be a way to tell excel that the decimal place should only display .
and .2 before moving up to the next whole number.

I don't even know if this is possible, and I ask you to pardon me fo
the unclear description. Thank you! :confused

 

[Fred Smith]

What you want is 20 + 6/10. The following should do it for you:

=int(days/7)+mod(days,7)/10

 

[PhoebeB]

Thank you, that worked marvellously

 

[Ron Rosenfeld]

I am trying to divide the amount of days to return its equal amount of
weeks. For example, with 146 days, there are 20 weeks and 6 days. Is
there a way to divide 146 to return 20.6, with the decimal being the
number of days left in that specific week? This is similar to a
baseball/pitching statistic, if a pitcher pitches 5.2 innings (2 outs
is the decimal place). To add a list of stats like that there needs to
be a way to tell excel that the decimal place should only display .1
and .2 before moving up to the next whole number.

I don't even know if this is possible, and I ask you to pardon me for
the unclear description. Thank you!

=DOLLARFR(146/7,7)

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

How?

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.

--ron

 

[Sandy Mann]

What you want is 20 + 6/10. The following should do it for you:

=int(days/7)+mod(days,7)/10

And if you want to add up a column of weeks <point >days then try:

=INT(SUM(INT(E1:E3))/7)+INT(SUM(MOD(E1:E3,1)*10)/7)+MOD(SUM(MOD(E1:E3,1)),0.
7)

entered as an array formula (Ctrl + Shift + Enter)

HTH

Sandy

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk