How to find out a time

[Guest]

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?

 

[Guest]

Keith,

Put this alingside your first time and drag down:-


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

Mike

 

[David Biddulph]

=--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")