How to create random Kilometer figure per day from a montly change of days and km driven

[Washington]

Dear reader

I am hoping that you would be so kind as to help me with the following for Excel. Every month I need to create a driving report. It has a varying number of days (say 25 to 30) and varying figure of kilometers driven that month (say 400 km for January)

If the days for January are 25 and the km are 400 then I would like an output of 25 figures but all randomly created so that it shows that I have driven a different route that day.

I have looked at RAND but I just cannot figure how to do this especially since I need to allow for manual input of the days and km to change every month.

For demonstrating purposes this is what the output for 25 days should look like:

Day 1 - 13,2 km
Day 2 - 17,4 km
Day 3 - 20,3 km
Day 4 - 11,3 km

and so on up to 25 days with a total sum of 400 km.

I hope somebody can help me!

Thank you very much in advance! :-)

[Melvinrobb]

Here is my solution.
Put your total KM, and # of days in column K, and your random KM should display in column E.

[Washington]

Just superb .. thank you! :-)