Hi,

I'm stuck on a comarison of times problem.

My time column is formatted as "dd/mm/yyyy hh:mm:ss" although the
cell is formatted as hh:mm:ss

I'd like a comparison to say if the time is less than say 14:00 then
TRUE else FALSE but a simple IF (A2<$C$1,"TRUE","FALSE") doesn't work.

cell C1 is 14:00:00 formatted as hh:mm:ss

A simple time subtraction works OK ie A2-C1

If I could get rid of the DATE part of the field then the comparison
works OK. Trying a RIGHT function to just put the time part in a column
by itself doesn't work.

Any ideas, as I'm stuck.

regards

Davy