Trying to get the first time from a xls report

[Barneybeardsall]

Hi all, loving this site and already picked up some tips and tricks, so thank you.

I have been given a report from our security system and within the file I have three columns, Date, Time and User, every time a user swipes their pass on the system (could be multiple times in one day) the system records the time the pass was swiped.

What I am trying to do and not sure if this is possible in Excel, is report by Date and User, but only show the first time on that date that the user swiped their pass, effectively the first time they came on site...

Does anyone have any ideas on how to get this?

Thanks in advance.

 

[Abdul Matheen]

Hi,

Can i get the sample file so that i do under stand your requirement correctly.

Regards
Abdul Matheen

 

[aparvez007]

Hi Barneybeardsall,

Please check this.


Regards,
pAvi

 

[json]

hhmmm.... uploading a sample would be helpful as the layout will play a role in the solution

from what i see, we could use the MIN function to find a persons first/earliest swipe time... but you'll need to be able to automatically establish the MIN for each person separately... not as a whole.... which brings us back to the layout.

 

[Barneybeardsall]

Hi Guys, please find attached a sample file with dummy user data

 

[amp_82]

Are you ok with it in a pivot table? Then the attached may be what you're after

 

[bobhc]

Good day Barneybeards

If you have not done already you will help yourself if you take a moment to read this link

http://chandoo.org/forum/forums/new-users-please-start-here.14/

Why not just turn your data into a table and filter on time and user.

 

[Barneybeardsall]

Thanks Guys, I'll take a look.