View Single Post
  #2  
Old 04-27-2005, 12:27 PM
tech tech is offline
Member
 
Join Date: Apr 2004
Posts: 74
Default Re: another Excel question for you brilliant OOTiots!

=IF(HOUR(A1)<6,1,IF(HOUR(A1)<12,2,IF(HOUR(A1 )<18,3,4)))
Reply With Quote