Hi All,

I'm hoping that someone can help me with this formula

I have a process (D14) then the Start time (G14), End time (H14) and Pass or
Fail (I4), if the specific process takes longer than it should do then it's a
fail (the formula works for this). The time's are formatted dd/mm/yyyy
hh:mm:ss

=IF(OR(D14="process1",D14="process2",D14="process3 ",D14="process4",IF(H14<=G14+"01:00:00","Pass","Fa il"),IF(OR(D14="process5",D14="process6"),IF(H14<= G14+"23:59:59","Pass","Fail")))

The problem is this is....for example "process7" must be completed by 2pm
(14:00) on the same it was started.
Can someone please tell me what formula I need to make this work and how can
I other process with different finishing times?

I hope that I have explained this ok.

Thanks in advance,

Gav.