| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert meters to feet/inches | Excel Worksheet Functions | |||
| How do I convert Meters to Feet and Inches? | Excel Worksheet Functions | |||
| convert 1.2 miles to meters | Excel Discussion (Misc queries) | |||
| Formating to show square meters ie m2 | Excel Discussion (Misc queries) | |||
| formula for converting yards to meters | Excel Worksheet Functions | |||
Linear Mode
