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.

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.

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.

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.

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.