Convert time cell
 

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

Convert time cell
 

Hi
see:
http://www.xldynamic.com/source/xld.Rounding.html#time

--
Regards
Frank Kabel
Frankfurt, Germany

"Gareth" schrieb im Newsbeitrag
...
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