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.
|