IF CONDITION to mark PRESENT, ABSENT and LATE COMING

[uswyne]

A	B	C	D
Day	Time In	Time Out	Remarks	Formula
Friday	7:50:01	14:30:35	Present	=IF(A3="Saturday",(IF(B3>=TIME(9,0,59),"Late Coming","Present")),(IF(B3>=TIME(7,50,59),"Late Coming","Present")))
Saturday	9:02:01	14:00:45	Late Coming	=IF(A3="Saturday",(IF(B3>=TIME(9,0,59),"Late Coming","Present")),(IF(B3>=TIME(7,50,59),"Late Coming","Present"))) <tbody> </tbody>
Sunday	OFF DAY	OFF DAY
Monday	7:51:01	15:00	Late Coming	=IF(A3="Saturday",(IF(B3>=TIME(9,0,59),"Late Coming","Present")),(IF(B3>=TIME(7,50,59),"Late Coming","Present"))) <tbody> </tbody>
Tuesday			Absent	?

<tbody>
</tbody>

For Late Coming and Present I use above mentioned formula. but what would be the formula to mark Absent If Cell B is Blank?

 

[Gerald Higgins]

Perhaps

=if(B3="","Absent",IF(A3="Saturday",(IF(B3>=TIME(9,0,59),"Late Coming","Present")),(IF(B3>=TIME(7,50,59),"Late Coming","Present"))))

 

[uswyne]

Thank you very much, some time mind won't work?