How do I compare two times to see if one is "late" or "on time"?

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?

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

where A2 is the start time
--
HTH

Bob Phillips

"AuditorGirl" <AuditorGirl@discussions.microsoft.com> wrote in message
news:ED3A66DF-A4F2-4980-8FE2-88CE184681FB@microsoft.com...
> 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?

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

where A2 is the start time
--
HTH

Bob Phillips

"AuditorGirl" <AuditorGirl@discussions.microsoft.com> wrote in message
news:ED3A66DF-A4F2-4980-8FE2-88CE184681FB@microsoft.com...
> 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?