Blank Cell
"Peo Sjoblom" wrote...
Do you want entries in both C4 AND T4 then use
=IF(AND(ISNUMBER($C$4),ISNUMBER($T$4)),HOUR(IF($T $40.5,$T$4-0.5,IF($T$41/2
4,$T$4+0.5,$T$4)))&TEXT(MINUTE($T$4),"00"),"")
Could be shortened to
=IF(COUNT($C$4,$T$4)=2,SUBSTITUTE(LEFT(TEXT($T$4," h:mm AM/PM"),5),":",""),"")
if you want entries in either C4 OR T4 use
=IF(OR(ISNUMBER($C$4),ISNUMBER($T$4)),HOUR(IF($T$ 40.5,$T$4-0.5,IF($T$41/24
,$T$4+0.5,$T$4)))&TEXT(MINUTE($T$4),"00"),"")
Could be shortened to
=IF(COUNT($C$4,$T$4),SUBSTITUTE(LEFT(TEXT($T$4,"h: mm AM/PM"),5),":",""),"")
--
To top-post is human, to bottom-post and snip is sublime.
|