View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Keith Keith is offline
external usenet poster
 
Posts: 262
Default How to find out a time

I have a column with the format of custom hh:mm. As you can guess its a list
of times.

In another column I want to have a 0 if the time is not between 8am and 6pm
and and a 1 if it is.

How can i do this?