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