Hi all,

I am trying to come up with a function that looks at the time in a cell (in 24 hour format) and, depending on whether that time is between (08:00 and 18:00) or between (18:00 and 8:00 the next morning), then a rate is chosen from another cell.

In my limited knowledge of this subject, I tried:

=IF((B3<8:0 or B3>18:0),1, 0)

the 1, 0 was simply to sign a True or False to the condition so that the suitable rate can be selected (i.e., if the result is 1 then look at the value in X1, else look at the value in y1)

This yields an error message, so my next step was to go to the user guide and see if I could find anything there, but I’m not having any success.

I would be very grateful for any help, hints, or even just being pointed to where I can find information that will help.

Thanks,

Gus.