{"id":948,"date":"2018-05-04T20:05:31","date_gmt":"2018-05-04T20:05:31","guid":{"rendered":"https:\/\/when2work.com\/help\/mgr\/?page_id=948"},"modified":"2018-07-12T00:17:15","modified_gmt":"2018-07-12T00:17:15","slug":"time-off-report-exclude-weekends","status":"publish","type":"page","link":"https:\/\/when2work.com\/help\/mgr\/h-sub-time-off-cannot\/time-off-report-exclude-weekends\/","title":{"rendered":"Time Off Report &#8211; Exclude Weekends"},"content":{"rendered":"<p>When using our\u00a0<strong>REPORTS<\/strong>\u00a0section you can enter any date range but the reports will include all dates in that range, so here are a couple workarounds you could consider:<\/p>\n<ol>\n<li>\n<p>Create two separate\u00a0<strong>Time Off<\/strong>\u00a0exports for the Monday-Friday of the first week then Monday-Friday of the second week, then you could total your two reports for the two \u2018workday\u2019 weeks.<\/p>\n<\/li>\n<li>\n<p>Use our \u2018<strong>Assigned Shifts Details \u2013 General<\/strong>\u2019 export and include the \u201cDay of Week\u201d field in export then open file in Excel and sort by day of week so you can filter out your weekend shifts before you run your totals in Excel.<\/p>\n<\/li>\n<li>Or if you do not use\u00a0Categories\u00a0for other purposes, you could create Categories like \u2018Wkday\u2019 and \u2018Wkend\u2019 then edit each of your shifts to associate them with the appropriate Category for whether they are weekday or weekend shifts.\u00a0 Then you could run your reports and choose to include just the weekday Category shifts so it automatically gives you just the totals for any date range for your weekday shifts.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><span class=\"extrawords\">run time off reports that do not include weekends<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When using our\u00a0REPORTS\u00a0section you can enter any date range but the reports will include all dates in that range, so here are a couple workarounds&#8230;<\/p>\n<div class=\"more-link-wrapper\"><a class=\"more-link\" href=\"https:\/\/when2work.com\/help\/mgr\/h-sub-time-off-cannot\/time-off-report-exclude-weekends\/\">More<span class=\"screen-reader-text\">Time Off Report &#8211; Exclude Weekends<\/span><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"parent":900,"menu_order":16,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/when2work.com\/help\/mgr\/wp-json\/wp\/v2\/pages\/948"}],"collection":[{"href":"https:\/\/when2work.com\/help\/mgr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/when2work.com\/help\/mgr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/when2work.com\/help\/mgr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/when2work.com\/help\/mgr\/wp-json\/wp\/v2\/comments?post=948"}],"version-history":[{"count":3,"href":"https:\/\/when2work.com\/help\/mgr\/wp-json\/wp\/v2\/pages\/948\/revisions"}],"predecessor-version":[{"id":2107,"href":"https:\/\/when2work.com\/help\/mgr\/wp-json\/wp\/v2\/pages\/948\/revisions\/2107"}],"up":[{"embeddable":true,"href":"https:\/\/when2work.com\/help\/mgr\/wp-json\/wp\/v2\/pages\/900"}],"wp:attachment":[{"href":"https:\/\/when2work.com\/help\/mgr\/wp-json\/wp\/v2\/media?parent=948"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}