I am trying to figure out how to calculate the time that is spent at a particular location I have the arrival and departure times. When ever I try to use the field calculator to solve for the time spent anything over a few seconds it has the totally wrong time for.
For example the first column is the departure time and the second the arrival, but the elapsed time gets wonky after you go over a full minute.
Initially the TransTi column was written 74657 and not as time. It is likely that is where things are going wrong, but other than changing the number format on properties to custom I could not figure out a way to get the column to have the : between the numbers as they should.
Currently my field calculator just has [E_DTM_tim] - [TransTi]
Any help would be appreciated.