Adding to a requirement....

[sumospim]

Hi all and apologies for poor title but very difficult to explain (well a least i am finding it so...)

So i have some data and let's say a job comes in at 1300 that takes 1 person. But that job takes say 5 hrs for that 1 person.

Another job comes in an 1400 and that job takes 5 hrs ; so then at 1400 we have a demand of 2 people

Well not explaining very well but is there a way in excel in carrying forward that demand of 1 person for 5 hrs and then stop?

Many thanks

Simon

[DavidJAllen]

sumospim,

See attached.

Excel stores times and dates as numbers so you can find the end date/ time by adding the job duration hours to the end time. Note you need to divide the job duration hours by 24 as this is how excel stores it.

Then it is a case of checking whether the time you need to find resources for is greater than the start time and less that the end time. The formula below does this.

=SUMPRODUCT((A2:A12<=E2)*(C2:C12>=E2))

Note that the way you get Excel to display the date and time is down to the cell formatting. I have used dd-mmm-yy hh:mm

Regards

David

[popipipo]

How about this?

[sumospim]

Cheers both for the above...I think I understand the above. I have attached the data which I have arrived at but then realised it is not a true representation as each head (person/requirement) is required for 5 hours and then not so....Would the above formula still be applicable?

[sumospim]

Hi all, just bumping this; did anybody have chance to look at the attachment...?

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.