Cell D35 on sheet1 is formatted as time ([hh:mm]). It can
contain anything from 00:00 to 123:45

What I want to do is round the time to the nearest half an
hour and then convert it to text. For example, if D35 had
10:15 (0.427083) in it then I want B6 on sheet2 to be 10:30

Any help gratefully received.

Gareth