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

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

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

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