"Harlan Grove" wrote...
...
=IF(COUNT($C$4,$T$4)=2,SUBSTITUTE(LEFT(TEXT($T$4, "h:mm AM/PM"),5),":",""),"")
...
=IF(COUNT($C$4,$T$4),SUBSTITUTE(LEFT(TEXT($T$4,"h :mm AM/PM"),5),":",""),"")

Wrap the SUBSTITUTE calls inside TRIM to eat possible trailing spaces.

--
To top-post is human, to bottom-post and snip is sublime.