Stock coverage next hours

[Anonymous]

Hello,

I have a little issue in order to calculate if the stock is covered or not for the next order(purchase).

In the Excel sheet attached.

Column A are the references.

Column B is the stock level

Column C are the next order (purchase) coming for the next 3 hours.

Column D should be my % of coverage.

I 'm lost in the calculation

the first expression is to sum the stock column  B, the second to sum the next order column C.

the third expression in column D is to calculate the coverage pourcentage. This doen't work.

If my stock is higher than the order, I should see 100% because I'm cover.

My orders have a lead time of 4 hours. Nice to have if possible the coverage per hours .

the data with the hours received are in a different table (join in the discussion too)

thanks you so much

Regards

Fab