If you pout the time the tool is down in A1 using time format hh:mm and
if the produced is normally 100 per hour you can use

=A1*1440*100/60

formatted as general NOT time

you might want to round it to the nearest integer since if you put in 2:25
it will be decimals involved

=ROUND(A1*1440*100/60,0)


Regards,

Peo Sjoblom

"Mally" wrote:

I am designing a spreadsheet for work and want to keep track of how many
items have not been produced due to tool down time.

If i have a target of e.g.100 per hour and the tool is down for e.g. 2hours
(02:00) how can i write this in a formula to show that i have lost 2 hours
which would equal 200 displayed in a column in this example.