if and + formula
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
|