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
|