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?

How to find out a time
 

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?

How to find out a time
 

=--AND(A1=--"08:00",A1<=--"18:00")
or (if the column might be date & time, formatted to show just the time)
=--AND(MOD(A1,1)=--"08:00",MOD(A1,1)<=--"18:00")
--
David Biddulph

"Keith" wrote in message
...
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?