Thread: another Excel question for you brilliant OOTiots!
View Single Post
  #8  
Old 04-27-2005, 01:27 PM
swolfe swolfe is offline
Senior Member
  
Join Date: Nov 2004
Posts: 632
Default Re: another Excel question for you brilliant OOTiots!
a less cludgy solution:

=INT(HOUR(A1)/6)+1

you'll probably have to manually format the column as an integer
Reply With Quote