| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula needed
I have a cell that is in hours and minutes of work time lost in (A1), Is
there a formula that i can use to calculate the average miles lost at a ratio of 1:00 hour = 10.73 miles and the answer be in (B1) in mileage Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula needed
Try
=(((A1)*1440)/60)*10.73 Mike "jackrobyn1" wrote: I have a cell that is in hours and minutes of work time lost in (A1), Is there a formula that i can use to calculate the average miles lost at a ratio of 1:00 hour = 10.73 miles and the answer be in (B1) in mileage Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula needed
Or, more simply:
=a1*24*10.73 Excel stores times as fractions of a day. To convert to hours, multiply by 24. Regards, Fred. "Mike H" wrote in message ... Try =(((A1)*1440)/60)*10.73 Mike "jackrobyn1" wrote: I have a cell that is in hours and minutes of work time lost in (A1), Is there a formula that i can use to calculate the average miles lost at a ratio of 1:00 hour = 10.73 miles and the answer be in (B1) in mileage Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula needed
Brilliant thank you
"Fred Smith" wrote: Or, more simply: =a1*24*10.73 Excel stores times as fractions of a day. To convert to hours, multiply by 24. Regards, Fred. "Mike H" wrote in message ... Try =(((A1)*1440)/60)*10.73 Mike "jackrobyn1" wrote: I have a cell that is in hours and minutes of work time lost in (A1), Is there a formula that i can use to calculate the average miles lost at a ratio of 1:00 hour = 10.73 miles and the answer be in (B1) in mileage Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
| Formula needed | Excel Discussion (Misc queries) | |||
| Formula needed please... | New Users to Excel | |||
| Formula needed - is this possible? | Excel Discussion (Misc queries) | |||
| Formula needed | Excel Worksheet Functions | |||
Hybrid Mode
