J
James
In my sheets for work i have basic formulaes to work out a basic time such as
=SUM(F140/7+H140+J140-60)
Which is this the amount of packs per hour (f140) divided by how many packs
per minute (7) plus how much downtime (h140) plus the change over product
time (j140) take away 60.
Which gives a result of something like 13.85
Obvioulsy this is not in a time formatt.
At the end of the week it could look like 1363.99
How can i set the formulae to give me an actuall time so each one would not
need someone to look at it a go "oh thats so many hours and minutes", so that
it does it by use of a formulae.
Cheers James.
=SUM(F140/7+H140+J140-60)
Which is this the amount of packs per hour (f140) divided by how many packs
per minute (7) plus how much downtime (h140) plus the change over product
time (j140) take away 60.
Which gives a result of something like 13.85
Obvioulsy this is not in a time formatt.
At the end of the week it could look like 1363.99
How can i set the formulae to give me an actuall time so each one would not
need someone to look at it a go "oh thats so many hours and minutes", so that
it does it by use of a formulae.
Cheers James.