Forum Discussion
h
Do you want to confirm if one of the cells for the time is blank?
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.
