Formula help involving a Time value please.
 

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.

Formula help involving a Time value please.
 

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

phowe43 wrote:
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.

Formula help involving a Time value please.
 

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

=A10/Hour(A8)

"phowe43" wrote:

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.

Formula help involving a Time value please.
 

Thanks folks. Both work...just different approaches.
"akphidelt" wrote:

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

=A10/Hour(A8)

"phowe43" wrote:

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.