You can use the sales rep check-in data to calculate how much time your sales reps spend for each customer visit.
- Log in to the Onsight web console at https://sales.onsightapp.com.
- Click on ‘Check-ins’ from the left-hand side menu.
- Click on the ‘View data’ menu item.
- You can filter by customer or by sales rep user or by date range.
- Select the rep check-ins by selecting the check box on the left hand side.
- Click the ‘Download’ button. The data will be downloaded in Excel format.
- Open the file in Excel.
- ‘Check-In Date Time’ is in column G. ‘Check-Out Date Time’ is in column I.
- Go to the end of row 2 (the first row of data) and in a new column, type this formula: =I2-G2
- Copy this formula to all the rows.
- Highlight the column. Right-click on the column, choose ‘Format Cells’, select ‘Custom’, and choose or type in h:mm:ss
- You will now see the time spent on each visit in this format: hours:minutes:seconds.