Dividing meters by hours = meters per hour
Try this:
=IF(B1="","",ROUND(A1/(B1*24),2))
Custom format: 0.00"m/h"
--
Biff
Microsoft Excel MVP
"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
|