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.
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.