Hello experts, I have to make a time sheet base on data given, I took the MIN entry and MAX exit for each day, I solved the problem if employee have no entry or exit to give me zero but looking further a lot of them have "entry or exit only" in a day because they work night shift and enter one day and exit on the next day.
I am content with the resulting hours for Day Shift but Night shift is a problem that I am stuck with, I tried and researched but failed.
I need help on function/formula that will give me hours worked by night shift.
I attached sample table, all and any suggestion is appreciated.
Bookmarks