View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default Dividing meters by hours = meters per hour

=A1/(B1*24)

--


Regards,


Peo Sjoblom

"Igorin" wrote in message
...
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