In short, I've got a file that is for serviced machines and the times our reps are working on them. It could take hours and days.
I've finally figured out how to properly formulate the total hours based on the times they checked in and out. However the "Total onsite" is auto calculating as soon as I enter the "Arrival" time or which ever time is first in the row. The only way to physically counteract this is to go back and remove the already auto-corrected time from the "total on site" and input the "departure".
In edit mode:
Before correcting the time:
Hopefully this isn't overly complicated and it has a simple answer.
once you press the enter (or tab) button the selected field jumps to a random position. I tried to rectify this by deselecting this:
Any advice is welcome.