Employee Timesheet (1 Viewer)

[LarryE]

Request to share a drop box for month so we can filter which month attendance and a drop box for other employee

You asked how to do that. So I wondered if you were able to do it. As you have learned, you cannot use Max or Min or First or Last to get your Log In and Log Out dates and times. When you receive the EXCEL data, every SECOND record is a Log Out date and time for each employee. So each person could have times that span over two different days. I was able to translate your EXCEL imported data to dates and times logged in and logged out for each employee. That way, dates and times spent in attendance are accurate. Using Max or Min or First or Last will not give you accurate times spent in attendance.

I also created some code that automatically imports any file you select.

I can attach the file if you wish to look at how that was done.

 

[joshirohany]

Sure LarryE....

 

[LarryE]

Sure LarryE....