Try this equation:

=IF(B7-A70, "late", "ok")

eg:

Due time Start time result
7:00:00 6:58:00 ok
7:00:00 7:00:00 ok
7:00:00 7:00:01 late

Have your employee name (or ID) and dates as separate columns (better for
sorting etc.)

Format your A & B Columns as time (hh:mm:ss), you can subtract either one
from the other, but you have to ensure that you don't result in a negative
time, as Excel won't like it. (Lets be honest you can't actually have
negative time)

"mrice" wrote:


You could test the value of your subtraction for being greater than or
less than zero and get your tru or false that way.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=540312