Minutes multiplied by a number to give a number

[Guest]

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.

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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