Thanks again

In cell A1 i have typed 100 for the per hour figure (in general format

In cell A2 i have type 02:00 for hours down (in time format)

My formula is then =ROUND(A2*1440*A1/60,0) like you stated and it gives me
the correct result so i think i maght have cross referencing formulas
somewhere so i will look into it. Thanks again

Mslly

"Peo Sjoblom" wrote:

If you are going to use that formula you need to use time format that excel
see as time, not decimal hours, if that's the case (if you use 2.5 for 2:30
hours) just use

=A1*100

What is the time that returns 29000 where tool target is 100?

Regards,

Peo Sjoblom


"Mally" wrote:

Thank you for the fast reply

But what is the 1440 in this sum, and i get a answer of 29000 when it should
be 200

"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.