View Single Post
  #1   Report Post  
Brandi
 
Posts: n/a
Default Calculating tvl time in Excel 2000 Rev.9.2720

Can someone please help?
On timesheet in Excel, there are 4 columns:
Travel Time to site
Arrival time at site
Departure time from site
Return Travel time
If more than one job is done in a day, when traveling from a billable job to
a Maintenance job and then to another billable job and returning to
home/office, how can the return travel time be calculated for the two
billable jobs to arrive at the total time for the billable jobs that day?
Any assistance will be much appreciated. Thank you.
bg