The Time & Mileage report export enhancements will provide a clearer format that’s more consistent with the Time & Mileage report and easier to manipulate (e.g. summing total time for a team or hours for payroll). With these new updates, you will now have a better matching order, format, and labels in your Time & Mileage exports.
The new export format still includes all the data you're familiar with receiving, but now some columns will have a different name and include data in a more helpful format.
1. When you've selected the Time & Mileage Tracking activity, you will see a green"Export" button.
2. Your spreadsheet data will look like this.
We explain the meaning of the columns below:
Column A: Representative ID
Column B: Representative name
Column C: Date – This is the date for which the time and mileage are recorded
Column E: Workday end time – This is the time when your rep ended their day
Column F: Mileage start – This is the value of your start mileage
Column G: Mileage end – This is the value of your mileage at the end of your workday
Column H: Mileage total – This is the total mileage for your workday
Column I: First visit time- This is the time of the first visit
Column J: Last visit time–This is the time of the last visit
Column K: First to last visit time–This is the value in minutes of how much time has passed between the first and the last visit
Column L: Remote visit count
Column M: Visit count
Column N: Time at place (minutes)
Column O: Time remote (minutes)
Column P: Time in travel (minutes)
Column Q: Pause time (minutes)
Column R: Break time (minutes)
Column S: Break count
Column T: Working time total (minutes)
Coulmn U: Time at place (hh:mm)
Column V: Time in travel (hh: mm)
Column W: Breaks time( hh:mm)
Column X: Working time total (hh: mm)
For users that are adjusting their previous export templates to match the new format, please follow the changes below:
- Update data formats from text to numeric, date and time where applicable
- Date should not include time (currently it always has “12:00:00 AM” after the date)
- All time columns will be shown in minutes, and the time columns in the hh:mm format will be included at the end
- Rename “Begin datetime” to “Workday start time” and only include time
- Rename “End datetime” to “Workday end time” and only include time
- Mileage start/end - include (mi) or (km) in column header
- Rename “No of visits: to “Visit count”
- Rename “Min of visits” to “First visit time” and only include time
- Rename “Max of visits” to “Last visit time” and only include time
- Rename “Min/Max visits time” to “First to last visit time (minutes)”
- Rename “Time spent” to “Time at place (minutes)”
- Rename “Pause time” to “Pause time (minutes)
- Rename “Breaks time total” to “Breaks time (minutes)”
- Rename “Breaks total” to “Breaks count”
- Add “Working time total (minutes)” - in addition to “Working time total (hh:mm)”
- Rename “Working time total” to “Working time total (hh:mm)”
- Rename “Time at place” to “Time at place (hh:mm)”
- Rename “Time in travel” to “Time in travel (hh:mm)"