View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
phowe43 phowe43 is offline
external usenet poster
 
Posts: 12
Default 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.