hi
the following formula allows me to adjust the start time of an error
and it works fine

=IF(AND(P30<$S$27,P30<$S$27),"06:00:00",TEXT(MOD(P 30,1),"hh:mm:ss"))

what i am trying to do is ammend the formula to allow me to check
another cell for a day

cell n 30 = Saturday

=IF(AND(P30<$S$27,P30<$S$27),"06:00:00",TEXT(MOD(P 30,1),"hh:mm:ss"),
if(n30 = "Saturday"))
this is not working
can anyone point me in the right direction please

thanks kevin