I will also need a macro/button that will clear the entire Duration field before adding anything new at the start of the day.
I will work on this later today as I have time. This will require an update query to be run against the table. If you want to give it a shot yourself, then look at this

Microsoft Access Update Query - YouTube

You will want to update the value in the duration to NULL