Thankyou Harlan
-----Original Message-----
"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.
.