This is one option:

AA: 'Names'
AC: =MIN(IF($AA25=$C$2:$C$402,F$2:F$402))
AD: =MAX(IF($AA25=$C$2:$C$402,H$2:H$402--($H$2:$H$402<$F$2:$F$402)))

Ola Sandström


Result:
Moinuddin Khan 08:58 18:02
Varun Bhushan* 09:01 18:02
Shubha Khampari 08:28 17:07
Joseph Fernandes08:59 18:07
Nasreen Rahim 13:08 17:12
Hiren Sardesai 06:10 17:33
JIHAN MENEZES 14:57 00:43
Marcellina Monis06:55 19:04

--
Message posted via http://www.officekb.com