Any help on how to make hours & minutes work to show if someone is late
Let's say you want to CF col A for any arrival times greater than 7:10 am
Select col A (A1 active), apply CF for Condition 1 using "Formula Is":
=AND(ISNUMBER(A1),A1--"7:10 am")
Format to taste
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---