How do I set up a formula for parts (or units) per hour?
Because Excel stores time as a fraction of a day. Reformat your cell to
general and you'll see that 6 hours & 24 minutes is something just a little
higher than 1 quarter of a day: .2666667 So, if you divide 13 by that
number you get a result of 48.75
"Ender-DI" wrote:
Oh, ok. I misunderstood what you had typed. My mistake. I have no idea
why it was giving me 120.00.
I still don't understand why you have to multiply the time by 24hours. I
entered the value in hours. 6hours. Why doesn't 13/6:24 (B2/B1) give me
the 2.03?
"Duke Carey" wrote:
I could have been clearer - using your numbers col C should NOT have shown
120 (as your example stated), it should have shown 48.75. After multiplying
the time value by 24 to get actual hours, the answer should have been a
little over 2
|