h

[Jdretti540]

h

[#2]

Do you want to confirm if one of the cells for the time is blank?

[#3]

Yes that along with any missing shifts between the two and any differences in shift length would be helpful.

[#4]

Can you Merge the tables based on a common key and highlight missing value with conditional formatting?

[#5]

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.