Converting kilometers to time in quarter hour decimals

[nurse_d_100]

Hello everyone,


I am trying to program a timesheet to take a staff members kilometres driven and convert it to a decimal using a 1minute = 1kilometre ratio. However where I work, we must express time in quarter hour decimals. 0.25=15 minutes, 0.5=30 minutes and so on.
Right now I am simply dividing the kilometres by 60 which gets me a random decimal number and then manually rounding that number to the nearest quarter hour.

Any help on this topic would be greatly appreciated.


Thanks

 

[AkaTrouble]

with you kilometres in A1

in A2

=((ROUNDDOWN((A1/15),0)))/4

 

[nurse_d_100]

Excellent, this worked perfectly!!

Thank you so much!

with you kilometres in A1

in A2

=((ROUNDDOWN((A1/15),0)))/4

 

[Scott Huish]

A bit shorter:

=INT(A1/15)/4

 

[nurse_d_100]

They both work very well, thank you so much.

A bit shorter:

=INT(A1/15)/4