I have been browsing through several forums and threads and keep getting formulas that either take the floor or ceiling which is not what I want. I have currently:

=floor(d2, "0:30")

Unfortunately this rounds something like 10:46 to 10:30, which I need to round to 11:00. Any help would be great! Thanks!!