How to use check-in data to calculate how long sales reps visit customers

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.
Back