Hi Team,

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.

Fields are:

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

many thanks

Scott

Maths:

the parenthesis help.

Then you have a NUMBER (of seconds), but you can also return a

time resultwhich could show the total hours, minutes and seconds. Returning as a time type saves having to format yourself with hours, minute & seconds.Beverly