Hi
=TEXT(A1,"hh:mm")

--
Regards
Frank Kabel
Frankfurt, Germany

"gareth" schrieb im Newsbeitrag
...
I have 09:30 in cell C35 (which is a value of 0.39583333).

I need to get 09:30 into cell G35 as text.

Any suggestions gratefully received.

Gareth