Convert 1.15 to 1.25 for time purposes.

[Jmcb1b]

I've been using decimals for time calculation. My totals output to the
exact minute. I'm needing my time to stay in the "0.00" format. But I'm
needing it to display in quarter hour increments.

example: 1.15 = 1.25
1.30 = 1.50
1.45 = 1.75


1.01 to 1.14 = 1.00
1.15 to 1.29 = 1.25
1.30 to 1.44 = 1.50
1.45 to 1.59 = 1.75

Is this possible?

Thanks in advance.

 

[Peo Sjoblom]

One way

=INT(A1)+(MOD(A1,1)/14.4*24)

or

=INT(1.15)+(MOD(1.15,1)/14.4*24)

 

[JanetW]

If you number is in A1:

=TRUNC(A1)+IF(MOD(A1,1)<0.15,0,IF(MOD(A1,1)<0.3,0.25,IF(MOD(A1,1)<0.45,0.5,0.75)))

 

[Stephen Bye]

=FLOOR(DOLLARDE(A1,60),0.25)