Hi Guys

Wonder if you might be able to give me a hand. I'm trying to figure out a whether there is a formula in excel that can help me with some interval issues I'm having.

So basically we want to record hourly services on our engines (trucks)

The services are as follows:

1) A Service - Occurring every 125 hours
2) B Service - Occurring every 250 hours
3) C Service - Occurring every 500 hours
4) D Service - Occurring every 750 hours
5) E Service - Occurring every 1000 hours, and
6) F Service - Occurring every 2000 hours.

Now, they way it works is if, for instance, the month of August had 500 hours then the service schedule would be:

125 hour service - occurring at 125 hours
250 hours service - occurring at 250 hours
125 hour service - occurring at 375 hours, and
500 hour service - occurring at 500 hours.

So that would be two (125 service), one (250 service) and one (500 service) for the month of August.

At the moment were entering this data manually into our excel cells and what I'm trying to figure out is whether there is a formula that can calculate this for me automatically if I just insert the number of hours for a given month. So if I change 500 hours for August to 1000 hours
the formula would change the fields to:

125 hour service - occurring at 125 hours
250 hours service - occurring at 250 hours
125 hour service - occurring at 375 hours
500 hour service - occurring at 500 hours
750 hour service - occurring at 750 hours, and
1000 hour service - occurring at 1000 hours.

Thank you all in advance for your assistance. Please let me know if you require any further details.

Regards

André