Dividing meters by hours = meters per hour

[Igorin]

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!

 

[Peo Sjoblom]

=A1/(B1*24)

--


Regards,


Peo Sjoblom

 

[T. Valko]

Try this:

=IF(B1="","",ROUND(A1/(B1*24),2))

Custom format: 0.00"m/h"

 

[sb1920alk]

Also, use the custom format:

0.00 \""m/h"\"

 

[Igorin]

Thank you very much!!!
--
igor

=A1/(B1*24)

--


Regards,


Peo Sjoblom

 

[Igorin]

Thanks a lot!!!




--
igor

Try this:

=IF(B1="","",ROUND(A1/(B1*24),2))

Custom format: 0.00"m/h"

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thanks a lot!!!

 

[Igorin]

Thank you.

--
igor

Also, use the custom format:

0.00 \""m/h"\"