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

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

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

Dividing meters by hours = meters per hour
 

Also, use the custom format:

0.00 \""m/h"\"

"Igorin" wrote:

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

Dividing meters by hours = meters per hour
 

Thank you very much!!!
--
igor


"Peo Sjoblom" wrote:

=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

Dividing meters by hours = meters per hour
 

Thanks a lot!!!

:-)


--
igor


"T. Valko" wrote:

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

Dividing meters by hours = meters per hour
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Igorin" wrote in message
...
Thanks a lot!!!

:-)


--
igor


"T. Valko" wrote:

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

Dividing meters by hours = meters per hour
 

Thank you.

--
igor


"sb1920alk" wrote:

Also, use the custom format:

0.00 \""m/h"\"

"Igorin" wrote:

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