If your columns are like this
A B C D
Name Subject Date Time

and dates in column C are real Excel dates (not strings) then
enter this formula in E2
=C2+TIMEVALUE(LEFT(SUBSTITUTE(D2,".",":"),8))
this one in F2
=SUMPRODUCT(--($A$1:$A$10=A2),--($E$1:$E$10=E2))1

and fill them down as necessary! In column F you'll get TRUE in case of
clashes, you can Autofilter them.
Formulae could become simpler if time values would appear in normal form,
e.g. 9:00 instead of 9.00, in this case formula in E2:
=C2+TIMEVALUE(LEFT(D2,8))

Regards,
Stefi

€žJack€� ezt Ã*rta:

Hi, Excel Stars,

I am puzzled with a task to find the potential time clashes when planning
exams.

After allocating times to diffrent subjects, there will be some of the
students got a timetable as below

Name Subject Date Time
Mary.............................................. ......................
Mary .................................................. ..................
Mary .................................................. ..................
Tom English Tuesday 2/10/08 9.00 am to 11.00 am
Tom Chemistry Tuesday 2/10/08 9.00 am to 11.00 am
Tom Math Wendesday 3/10/08 9.00 am to 11.00 am
Tom Chemistry Thrusday 4/10/08 9.00 am to 11.00 am
Jack .................................................. ......................
Jack .................................................. ....................
Jack.............................................. .........................

Out of 700+ students, there will be 5 to 10 students having time clashes (as
above) on their exam timetables.

Is there any way to use excel functions or macros to highlight the time
clashes?

much appriciated for your help!





--
Jack