Cross referencing formulas issues

[mdev]

Hi all
I am new to the forums here and desperately need some help. I am somewhat of a novice with excel but seem to be able to get by for most things. I have been asked to come up with a spreadsheet at work to calculate schedule compliance I just cant get a few things to cross link. I basically need it to take what ever person I copy from 'actual log in log out'(purely just data to use for testing), paste it to 'log in log out', hit calculate. it auto generates time out at that point so i'm good there. I just also need it to cross reference that person with the schedules tab in case they are out of compliance on sign in, break,lunch etc. and for totals to be on compliance sheet. Any help would be awesome as I have been pullin my hair out for three days

[MarvinP]

Hi mdev,

There are some problems with your existing data. The In and Out times are text and need to be converted to Timevalues to do much with them. I've created a table on your first sheet and then a Pivot Table. This may help you get to where you want to go. See the attached.

[mdev]

Thanks MarvinP
Not quite what I was looking for. I was more looking for something along the lines of an IF/VLOOKUP to compare the login logout times with schedules