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.
