How to pull weekly data from a turnstile database HELP!!

Hi All,

I am hoping somebody could help me, i am quite new to Excel, iv been trying learn/teach myself over the past year to better myself..

I feel i have progressed quite a bit, but now i have been hit will a challenge!!! i just don't know how to complete, basically..

We have turnstiles at work that our staff use to enter and exit the 3rd party site, all staff have an allocated ID card.. what i would like to learn is how to pull a full weeks data from, our customers turnstiles database for our staff only (the turnstiles have there staff included to and there is multipull entrees and exits).

I have attached a example of the spreadsheet and added a turnstile data tab, and a weekly data tab of which i would love to know how to pull the data i need.

I hope this makes sense, and i am not been to cheeky as now i feel like a failure lol.

HI, I have now paid 20 USD for the help i need, i didnt know you could pay for help

You dont need to and I feel you may not have explained your question correctly
C5 and D5 are the same value as the person arrive don the sunday and left on the monday (however as the question is phrased this is the earliest and latest value for sunday!

Can staff

• enter and exit twice in a day?
• Could staff
  f have arrived in the previous week and left in the week you are examining

on the 13th *CL575 came and went twice

c5 format as [$-x-systime]h:mm:ss AM/PM;; and enter as an array with shift control enter =MIN(IF((WEEKDAY('Turnstile Information'!$A$2:$A$1000)=INT(COLUMN(B2)/2))*('Turnstile Information'!$F$2:$F$1000='Weekly Data'!$A5)>0,'Turnstile Information'!$A$2:$A$1000))

d6 format as time =IFERROR(LOOKUP(2,1/((WEEKDAY('Turnstile Information'!$A:$A)=INT(COLUMN(B2)/2))*('Turnstile Information'!$F:$F='Weekly Data'!$A5)),'Turnstile Information'!$A:$A),"")




What do you wish to calculate as total time

HI thanks for the quick reply.. yes staff can enter multipull times when they are on site, as the smoking hut is outside the DC and thats were a few go for break, yes they can also work into the next/following week if they work a Saturday night week as they also work night shifts. its really hard to try and explain.

I have paid the fee now so there is no turning back, i was hoping, i would get an example on the attached spreadsheet thats why i paid the fee. I hope that makes more sense fella..

HI, I'm such a Clutts. Ho well you learn something every day . Apologies, thanks for letting me know

could i close this and pay the 20USD to have it done for me, honestly the past week as beaten down lol have you got a contact name i could ask, im so sorry im new to this help site. im so sorry