I'm not clear on what you are trying to accomplish. Are A1 and A3 start times and A2 and A4 end times? If so, then there are only 4.25 hours worked.

Why does A5 have today's date, 8:15 am? I don't understand the logic that leads to it.