Formula help involving a Time value please.

P

phowe43

Please help.

If cell A8 is a time value - 7:00 (total elapsed hours), and
If cell A10 is a unit value - 7 (total units)

I need to know units per hour. Simple case..this would be 1 unit per hour.
I'm trying to do a simply formula of A10/A7...and am getting some funky
numbers.

Any help would be appreciated.
 
B

Bob I

Not surprising, what is in cell A7? Try formatting the cell with the
formula as Number and then use =A10/(A8*24)
 
Top