Forum Discussion
h
Yes that along with any missing shifts between the two and any differences in shift length would be helpful.
Can you Merge the tables based on a common key and highlight missing value with conditional formatting?
- I think this may slightly more complex as some workers have multiple shifts. I am also looking to highlight for example any difference in clock_in time in Report A vs. In Time in Report B also clock_out time in Report A vs. Time Out in Report B.