Help on number(hours) divide calculations

Hi everyone (again)

Hoping someone can point me in the right direction regarding Numbers(hrs) and dividing, sample workbook contains drop down lists, Machines run for 8 hrs a day unless breakdowns and other factors anyway the easy part is column E downtime is calculated on Column D straight forward divide calculation, works well for a single row but is it possible to have a formula that see's the Machine name that had 2 jobs run in the 8 hours so therefor it needs to split the 8 hours 4 ways on 2 rows, see sample

Hope thats understandable lol

Thanks

Hi Jacc

Thanks for the reply, not quite what I was looking for but looks great, I will use your idea later when I have everything constructed

Hey Jacc

you can never get carried away we are all here to learn, I will be making notes on everything you teach me even if its not the solution to my question

and many thanks for your input

After some thought have decided on the old fashioned way of getting to the result (press a number key) lol instead of finding a formula or auto solution

Thanks for the help guys


Yes I give up too easily