My brain hurts now so please help, I will explain in simples terms.
Am trying to calculate the time a person has taking in travelling from home to base and then from when they left base to go back home.
Time departed home (Time Field) Time arrived at base (Time Field)
Time departed base (Time Field) Time arrived at home (Time Field)
Travel Time (calculation formula needed)
The problem I have is that I just need the calculation of how long it has taken from home to base and then how long it has taken from base to home.
At present if someone has been called out at 2:00 and they arrive at 2:30 do the job and leave at 4:00 and get home at 4:30 the travel time field calculates the time as 13:00.
what I want is the travel time which in the example above would be 1:00hr