Thankyou JE
"JE McGimpsey" wrote:
Use the last example I gave you - either format it to display no decimal
places, or use
=ROUND(A1/B1*60,0)
In article ,
Steved wrote:
Hello JE from Steved
using your example 0:21:26 can I have it showing 21 (Rounding up or down)
Thankyou
"JE McGimpsey" wrote:
One way:
Times are stored in XL as fractional days, so if you want to return XL
times, divide the result by 24:
=10/28/24 === 0:21:26
and format as a time. Or, if you want to use cell references.
A1: 10
B1: 28
C1: =A1/B1/24 === 0:21:26
Alternatively, if you want your result in minutes rather than an XL time:
C1: =A1/B1*60 === 21.42857
Format In article ,
Steved wrote:
Hello from Steved
I would like a formula to calculate the time it takes to travel 10
kilometres driving at 28 kilometres per hour.
Thankyou.
|