View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
James James is offline
external usenet poster
 
Posts: 542
Default Changing a number into time

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.