a better way,

array formulas, validate with ctrl + shift + enter

=MIN(IF((A1:A6="Doe, John")*DAY(B1:B6)=4,B1:B6))
=MAX(IF((A1:A6="Doe, John")*DAY(C1:C6)=4,C1:C6))

isabelle



Le 2012-10-15 16:06, isabelle a écrit :
hi,

array formulas, validate with ctrl + shift + enter

=MIN(IF(DAY(B1:B6)=4,B1:B6,""))
=MAX(IF(DAY(C1:C6)=4,C1:C6,""))

isabelle


Le 2012-10-15 08:30, a écrit :
Yes Isabelle, the data is in three columns name all the login times
during the day and all the logout times durning the day.