Macro/VBA to Auto Refresh + Auto Email

I've been working on this spreadsheet for work and I'm also going through classes for excel but I've yet to get into the Macro/VBAs. I'm wondering if someone that is good with this would be able to add a few things to this and do it for me by chance. I know this is a long shot but I'm trying to get this done for work but I just don't have the knowledge base right now on this and hoping it's something super simple for one of you.

What this sheet is going to do is employees are going to put the address the address field and will add the time they did this Shift+Ctrl+;. After the "2 hour" or "4 hour" window I want an email to get sent to the persons outlook saying hey stop slacking get this done slacker.

I'm looking for two things.

1. I'm looking for it to auto refresh so that the time is somewhat current 5-10 minute window.
2. Once it goes past the "2 Hour" or "4 Hour" window "REASSIGN" or "CANCEL" it would send an email to "Email Address" with the subject being the "Address" and the body being either "CANCEL" or "REASSIGN".

I don't know if this is extremely hard or not. But figured I'd give it a shot until I get MOS Certified and hopefully am capable of writing this information myself.

Thank you in advance for anyone that is able to help.

Follow Up Sheet.xlsx

Thanks anyways everyone for looking. Have a great rest of the week.