Good afternoon everyone.
Hi am having difficultly with this formula and I think it is probably easier than I am making it in my brain.
We essentially run jobs that start late at night. I need to calculate if the job met it's expected time....easy right?
so if the job ends at 1:26:55 and the expected is 1:30:00 it passes so the formula looks like this
=if(B2<=C2,"Pass","Fail")
however when the "clock" starts over I get an invalid function...for example
job ends at 23:59:10 and expected is 1:30:00 the same formula gives me a fail because it didn't recognize that is happened 2 hours early.
I need an IF or AND statement that helps it recognize that the job completed the day before....oh and to make it more fun I don't have dates...when the report was written it was just expected that all jobs would complete in the same 12 hour period.

Thanks in advance..
Michelle