I'm using Excel because I have to send this workbook to several people each day and they don't have access to Power BI. Also, I don't think Power BI would be useful here.
I have a huge Excel workbook I pull two reports into daily. Both reports contain two date/time columns to represent time in and out. The problem is one is a solid block of time, say 10 hours, and the other might have one block for the whole 10 hours or five 2 hour blocks within those two hours.
What can I do to connect these times together in a meaningful way? I am merging the two reports by date, user id number, and user last name. I can't use time because part of what I am trying to build is a way to look for discrepancies including missing one or the other. They have to have both.
Any ideas?
