PDA

View Full Version : Need Macro Unique based Max and Min time



online
06-16-2011, 04:06 AM
Hi All,

I have data multiple entry of people and their start time end time. I want to unique name and their min start time and max end time so that i calculate their spend total time. duplicate name should be deleted.
see below

AM Name Start Time End Time Kesavan G 13:30 2:00 PM Kesavan G 3:30 PM 4:30 PM Kesavan G 11:15 AM 12:00 PM Kesavan G 12:30 PM 1:15 PM
now i want like below from above data.

AM Name Start Time End Time Kesavan G 11:15 AM 4:30 PM
i have attached excel file in which data sheet have data and i want result like sheet2. but i want result on data sheet. Sheet2 is just for example.