I have a small problem here like I wrote in the title. How can I find out how many hours an employee has already worked in a particular day (Column H).
Given the fact is an employee may check in and check out multiple times per day.
With my current solution I need so many steps that I would rather not go with it: Split check in and check out time to 2 columns, line up check in and check out to 1 row, perform time difference calculation and then run SUMIFS formula to fill in the column H. This solution cannot account for the case that the last check in and check out fall on 2 consequent days.
Thank you for any suggestion.