Blank Cell
"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.
|