Hi Hope this is the right place for this, sorry if not and could you point me to the right place if not This is my problem I have two people sharing the running cost of caravan one person will use the caravan a lot more than the other. I'm trying to work out how to get at the cost for each person. The total running cost of the caravan From March to October is £2200.00 The season runs from March to October Names of people are Fred Tom Fred will use the caravan 30 days a year Tom will use it 8 days a year These could be more or less days The rest of the time would be empty. So Fred would have to pay more of the total cost than Tom Hope some one can help a dum blonde Thank you Jane Reply With Quote

Couple of solutions to your problem I am assuming that you want a formula and/or action to calculate days divided by the cost of the car. So you could use a simple function that says: =2200.00/C2 (THIS IS WHERE I STARTED WHEN I TESTED IT) and it should look like this when you use auto fill in your total box. Does this help? EMPLOYEE DAYS USED TOTAL DUE steve 4 550 dave 10 220 paul 3 733.3333333

Being a math guy first (Excel is my secondary skill), I have just the thing you need: Total cost of van divided by total user-days = 2200.00 / 38 = 57.89 Multiply each rider's days by 57.89: Fred: 30 x 57.89 Tom: 8 x 57.89 Maybe I'm the one who's in the wrong place, or maybe I just like dumb blondes.