Do some Excel Work -- 2

I need to correlate payroll data from PDF files and employee schedule data from Excel spreadsheets between two locations for the years 2014 and 2015. Not all the 2014 data is complete, so I'll interpret some of the data. Basically, I need to separate out the hours from 2 locations to determin how many hours were worked at each location by using payroll data in PDF (which is for 2 locations combined and a pay period of every 2 weeks ) and employee schedule data, which is weekly and is in excel