Your formula needs to look like this:

=IF(AND(H6TIME(15,30,0),H6<TIME(7,30,0)),41078,41 079)

an entry of 13:30 (1:30PM) in H6 returns 41079

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=467072