Hi All,
I was hoping that someone could help me out with a spreadsheet I am creating for identifying Login / Logout times for employees.
I am wanting to categorize each login / logout instance into one of 4 categories -
SINGLE - The employee logs in once at the start of the shift, and logs out at the end. (simple to do... it's more the others i'm having trouble with )
START - If the employee has logged in and out multiple times in one day this will be the first instance.
FINISH - If the employee has logged in and out multiple times in one day this will be the final instance.
MIDDLE - If the employee has logged in and out multiple times in one day (3 or more) this will be the segment(s) in between the start and finish.
I have attached a spreadsheet with a sample of what I have done so far. As you will see my initial thinking on how to do this was to identify each instance (eg. 1 out of 2. 2 out of 3 etc) then do a lookup based on the instance number to determine whether it was greater or less than the other and this would give me whether it was a start or finish. I am running into some problems with this solution though as I am having problems doing the lookup and comparing whether one is greater than the other.
The other problem I am having is the formula that I am using to count the number of instances doesn't distinguish if it is a different date - therefore I get many for each employee. If you open the spreadsheet you will see what I mean.
Sorry for the long winded post, I usually wouldn't post something like this but I am really stuck and I'm hoping someone will be able to lend a hand.
Thanks in advance!
Bookmarks