Formula needed

[jackrobyn1]

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

 

[Mike H]

Try

=(((A1)*1440)/60)*10.73

Mike

 

[Fred Smith]

Or, more simply:

=a1*24*10.73

Excel stores times as fractions of a day. To convert to hours, multiply by
24.

Regards,
Fred.

 

[jackrobyn1]

Brilliant thank you

Or, more simply:

=a1*24*10.73

Excel stores times as fractions of a day. To convert to hours, multiply by
24.

Regards,
Fred.