Consulting

Results 1 to 1 of 1

Thread: Need Macro Unique based Max and Min time

  1. 06-16-2011, 04:06 AM #1
    online
    online is offline
    VBAX Regular
    Joined
    Apr 2009
    Posts
    40
    Location

    Need Macro Unique based Max and Min time

    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.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules