I have a column of times in the format: hh:mm:ss PM. I need to do a move a value to a cell that depends on the time.
to move the value in G4 to this cell if the time in B4 is before 9:30 AM, I tried
=IF(B4<"9:30 am";G4;"")
=IF(B4<(9.5/24);G4;"")
with no joy either way.
So, how does one check to see if a time if before a constant time ?
--
Bill Drescher
william {at} TechServSys {dot} com
