Hello,
I was wondering if anyone could give me some tips on creating a Nintex workflow that will achieve the below goal of giving me a total number (in integers up to two dec place). I have a SharePoint list that tracks company store closures. I would like to achieve a total number of hours the Store was closed but I would prefer not to include non business hours (Sun-Thurs and Fri-Sat are known/set closed hours and do not differ in our Store locations.Here is what I was hoping for.
Compare difference between two date columns within SharePoint (so date/time Store closed and date/time Store reopened)
Exclude "closed/non business hours" and then get a total number with up to two decimal places to update the SharePoint list with.
I think my biggest struggling is determining which date types or functions to use in order to convert date/time and get the difference then subtracting based on number of days closed. I appreciate any tips on this!