Thanks Rishikrsaw,

I have tried that already, i can sort all the data but actually i want to calculate how many hours a employee have worked in a month. i need excel to calculate the man hours. so im trying to make a formula to do this. Kindly advice..

Regards,
bp