Hello everyone,
I am facing an issue to organize in order the checking time of each employee, to explain you our HR extract to excel each month the attendance report from a software and she place all excel files in a specific folder, with Query table I managed to combine all files that contain the folder, sorted out the date from A to Z, spited the column containing all working check time of the day in several columns (one column for each check time) but the issue that I have is that sometimes the employee forget to check at morning, afternoon or night (no rule on it will depend of each employee), that mean the working time order for each employee will be at different position.
For exemple :
Employee 1 : 07:30 11:58 13:31 17:28 18:01 21:00 --> So this is a normal situation, we have the working time in/out for morning, afternoon and night.
Employee 2 : 11:56 13:31 17:28 18:01 21:00 --> In this case the employee forget to check in at the morning, so the time order is not correct.
With this kind of record when I split out all time record in several columns I will get for exemple for the afternoon check in 13:31 for employee 1 (that is correct) but for the employee 2, 17:28 instead of 13:31.
I don t know how to give a logics to excel to split correctly the time in each column. I will be really glad if someone have a way to solve it.
Thank you
Geoffrey
Bookmarks