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
|