Thread: Blank Cell
View Single Post
  #4  
Old June 25th, 2004, 08:06 PM
Harlan Grove
external usenet poster
 
Posts: n/a
Default 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.