{"id":3961,"date":"2024-06-21T20:05:49","date_gmt":"2024-06-21T20:05:49","guid":{"rendered":"https:\/\/www.onsightapp.com\/user-guide\/?p=3961"},"modified":"2025-09-24T11:08:06","modified_gmt":"2025-09-24T11:08:06","slug":"how-to-use-check-in-data-to-calculate-how-long-sales-reps-visit-customers","status":"publish","type":"post","link":"https:\/\/www.onsightapp.com\/user-guide\/how-to-use-check-in-data-to-calculate-how-long-sales-reps-visit-customers\/","title":{"rendered":"How to use check-in data to calculate how long sales reps visit customers"},"content":{"rendered":"<p>You can use the sales rep check-in data to calculate how much time your sales reps spend for each customer visit.<\/p>\n<ul>\n<li>Log in to the Onsight web console at <a href=\"https:\/\/sales.onsightapp.com\" target=\"_blank\" rel=\"noopener\">https:\/\/sales.onsightapp.com<\/a>.<\/li>\n<li>Click on \u2018Check-ins\u2019 from the left-hand side menu.<\/li>\n<li>Click on the \u2018View data&#8217; menu item.<\/li>\n<li>You can filter by customer or by sales rep user or by date range.\n<li>Select the rep check-ins by selecting the check box on the left hand side.\n<li>Click the &#8216;Download&#8217; button. The data will be downloaded in Excel format.\n<li>Open the file in Excel.\n<li>&#8216;Check-In Date Time&#8217; is in column G. &#8216;Check-Out Date Time&#8217; is in column I.\n<li>Go to the end of row 2 (the first row of data) and in a new column, type this formula: =I2-G2\n<li>Copy this formula to all the rows.\n<li>Highlight the column. Right-click on the column, choose &#8216;Format Cells&#8217;, select &#8216;Custom&#8217;, and choose or type in h:mm:ss\n<li>You will now see the time spent on each visit in this format: hours:minutes:seconds.\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>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 \u2018Check-ins\u2019 from the left-hand side menu. Click on<span class=\"ellipsis\">&hellip;<\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"_links":{"self":[{"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/posts\/3961"}],"collection":[{"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/comments?post=3961"}],"version-history":[{"count":6,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/posts\/3961\/revisions"}],"predecessor-version":[{"id":4541,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/posts\/3961\/revisions\/4541"}],"wp:attachment":[{"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/media?parent=3961"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/categories?post=3961"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/tags?post=3961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}