=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?
|