Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Round number to the thousands without changing underlying number | Excel Discussion (Misc queries) | |||
Changing Time To Different Timezones | New Users to Excel | |||
Changing many references at a time. | Excel Discussion (Misc queries) | |||
Changing format of number without changing the value | Excel Discussion (Misc queries) | |||
stop number font size from changing each time i click on somethin. | Charts and Charting in Excel |