time calculations

[Lynton]

I have a simple spreadsheet that has columns of distance in miles ie 1.97
and a permited speed in mph ie 30 Mph I want to calculate in the next column the time required to travel that distance and that time rounded up to the whole minute. 1.97m @30mph = 4 mins etc. i have tried many different solutions but cant get it to work. I have tried to alter the format of the cells but cant just get it. any help apreciated.

 

[jasonb75]

Welcome to the board!

Try

=CEILING(1.97/720,"00:01")

Cell formatted as time.

 

[jasonb75]

Just in case you're now trying to figure out how to adapt that to other figures, the principal is

=CEILING(distance/(speed limit*24),"00:01")

Hope this helps.

 

[Lynton]

Many thanks works perfectly
Lynton