Keith,

Put this alingside your first time and drag down:-


=IF(AND(A1TIME(8,0,0),A1<TIME(18,0,0)),1,0)

Mike


"Keith" wrote:

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?