....this seems to be a slightly shorter way:

=TIMEVALUE(TEXT(A2,"00\:00"))

or

=TIMEVALUE(TEXT(A1,"00"":""00"))

Regards,
KL


"Domenic" wrote in message
...
Try...

=TIME(LEFT(TEXT(A1,"0000"),2),RIGHT(TEXT(A1,"0000" ),2),0)

or

=SUM(MID(TEXT(A1,"0000"),{1,3},2)/{24,1440})

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Format cell as
'Time'.

Hope this helps!

In article ,
"CPK" wrote:

Is there a function that will let me convert a values such as 800 to a
hh:mm
format?

Thanks.