Rounddown to nearest .50

[caspertg]

Hi Folks,

Please can somebody help me with rounding.

I am trying to round down after the decimal point to the nearest .5.

So in C22 i have the number result of hours worked from time format.
C21 shows something like 06:46 hours worked.
C22 converts that to number using *24 formula
which has the result 6.77(thanks for that thread by the way).

Now in C28 i need a formula that will always round down to the nearest .5.
So anything before the decimal should be ignored and anything after the decimal should be rounded down in thefollowing ranges:
.01-.49 down to .0
.51-.99 down to .5
And as u can see .0 &.5 should remain the same.

Thanks for providing a site like this. When running a home business with little to no funds avail I have been left to my own devices on many occasions and failed dismally until i found you guys.
So again thank you so much for taking time to help the lil guy out.

 

[mikerickson]

Try
=ROUNDDOWN(A1*2, 0)/2

 

[VoG]

Try

=ROUNDDOWN(C22*2,0)/2

 

[caspertg]

and that right there is super speed genius.
Thank you so much for the help.