Hello!
I'm using excel 2003 and I'm trying to make a excel staff file that would manage the time worked by employees. The data is exported from a acces sistem (the sistem just export in excell files the time when a worker entered and exit he does not calculate the total time spent). I've attached a excel file that with an example of what I want to do :
- in the sheet "Data exported from acces sistem" I'll paste the results from the access sistem
- in the sheet "Staff manager" I'll have just one table (the one who auto extracts the data from "Data exported from acces sistem" sheet); in the example I give you 2 tables first is where I want the formulas and the second is an example on who the first one should look like
In my opinion the formula for IN time for a person should be something like: =IF( both NAME and DATE from "Staff manager" sheet are found in "Data exported from acces sistem" sheet ; GET MIN of the IN TIME for that DATE ; " " )
This post is also open on mrexcel forum:
http://www.mrexcel.com/forum/showthread.php?t=570300
Bookmarks