View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Igorin Igorin is offline
external usenet poster
 
Posts: 41
Default Dividing meters by hours = meters per hour

Hello,

I hope one of ypu can help me I have two columns:

Column A shows length progress in meters.

Coilumn B shows time for that progress, in time (hours & minutes)

In Column C I need to calculate the progress per hour, i.e., divide A1 by B1
and get C1.

C1 should show the amount of meters per hour we have progressed (with the
cell format 0.00"m/h").

How can this be done?

Thanks for the help!
--
igor