Sync Board Based on Time Stamp Value

I am sending data in through the API. Its a time stamp of when a QR code is scanned
I have another board called Scheduling that has security guards schedules .

Based on the time the QR Code was scanned, I want to pre fill the Guard column based on who was scheduled to work on that day and the time stamp of the QR code falls within their shift. How can This be accomplished?

Video Explanation Here. Thanks.