Thanks for your response.
Do you just want a count of the total number of days worked, or broken out by time?
Broken out by time.
For instance:
employee timings:
Abhilash Pazhamkulangara 1/11/2014 7:58
Abhilash Pazhamkulangara 1/11/2014 13:00
Abhilash Pazhamkulangara 1/11/2014 13:59
Abhilash Pazhamkulangara 1/11/2014 17:01

i need to calculate the total timings for that particular day.
I used this formula
=SUMPRODUCT(--(C:C=C2),--(D:D=D2),K:K)
but it only sum up all the values.