@RandyHayes Okay so the calculations I am trying to get is this:
There are two columns that need to be calculated:
1.Travel time (the time it took them to travel to an destination of work)
2. Work Time (the time it took them to do a job/activity)
3. Daily Work Time ( the time it took them to do all the activities in a day and then minus meal time which is usually 30 minutes) (also travel time is not included in this even though it's an activity)
As you can see from the image below each rows represents each day, the first row the first activity they started at 7am and ended at 10 am and the 2nd activity is travel and they started at 10 am and ended at 11am, so what will be calculated in travel time is the amount of time travelled which is an hour and the work time calculation will only calculated time of other activities not including travel and that sums up to 3 hours. Now the Daily worked hour is is all activities excluding travel summed up and then the meal time which is 0.30 is taken away from the calculated hours worked. So basically the only did one activity that isn't travel on that day and that means the calculated sum is 3hrs and then we take 30 mins of so the total sum of the daily worked is 2h30mins.
I haven't used a formula yet to calculate these sums.
