View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

=IF(A2IF(WEEKDAY(TODAY())=6,TIME(12,15,0),TIME(12 ,0,0)),"Late","OK")

where A2 is the start time
--
HTH

Bob Phillips

"AuditorGirl" wrote in message
...
I need to compare project 'start time' to project 'deadline time' for

daily
projects. The deadline time for Sunday through Friday is the same, 12:00

AM,
but on Saturday the deadline is 12:15 AM. I need to be able to show if the
project is 'on time'--that is on or before the deadline time-- or 'late',
that is after the deadline time.

Any help?