Calculating Early Login & Last Logout

[noname]

Hi all,

I have a timesheet dump which has a Column for EmpCode viz
0,1,2,3,4,5, etc..
Next column is for StatusID where status means 1 = Login & 2 = Logout.
Next Column is for Date & Time Stamp (Long format).

Since the Login & Logout Date& TimeStamp lie in a single column, i
want to calculate, for each EmpID, the earliest time he logged in &
last time he logged out for the SAME day....

Also, if someone can find a way to find if the respective date falls
on a weekend or holiday...

if anyone has an idea using Worksheet function or VBA code to
accomplish this, please let me know....

EmployeeCode StatusID Time
-------------------------------------------------------------------
0 1 4/13/07 7:01 PM
0 1 4/16/07 1:03 PM
0 1 4/16/07 1:05 PM
1 1 4/2/07 4:03 PM
1 2 4/2/07 6:20 PM
1 1 4/5/07 10:14 AM
1 2 4/5/07 1:27 PM
1 1 4/5/07 5:52 PM
1 1 4/17/07 6:03 PM
1 2 4/17/07 6:39 PM
1 1 4/19/07 9:38 AM
1 2 4/19/07 6:02 PM
1 1 4/24/07 11:17 AM

Sheet2:
EmpCode Early Login Early Logout

 

[noname]

can anybody help me with this please?