Formula help involving a Time value please.

[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.

 

[Bob I]

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

 

[akphidelt]

If the 7:00 is formatted as time then try this

=A10/Hour(A8)

 

[phowe43]

Thanks folks. Both work...just different approaches.