Hi,
I have a working formula which works perfectly (thank you Chandoo.org), IF every day including Saturday has the exact same hours of operation.
I am using it to calculate the number of minutes spent on a task during the business hours.
However, Saturday is working a 6 hour shift instead of 12 so the formula breaks, and you cannot use networkdays twice, namely one part for mon-fri, and one for saturday only with different hours and then add them together because you don't know for sure that Saturday was the last day, it can absolutely roll over into the following week and get completed during a normal mon-fri.
I'm trying to figure out how to still use the networkdays.intl formula but let Saturday have different hours of operation..
The only thing that comes to mind at this time is that I might need a worksheet with columns for each day of the week and each row is a different date and each cell would contain the maximum number of minutes for that day, and one would have to add up all the cells between a starting and ending date, and then subtract the minutes not present on the last day.. this doesn't seem very practical.
Wondering if anyone has any ideas on what needs to be done.
Thanks!
I have a working formula which works perfectly (thank you Chandoo.org), IF every day including Saturday has the exact same hours of operation.
I am using it to calculate the number of minutes spent on a task during the business hours.
However, Saturday is working a 6 hour shift instead of 12 so the formula breaks, and you cannot use networkdays twice, namely one part for mon-fri, and one for saturday only with different hours and then add them together because you don't know for sure that Saturday was the last day, it can absolutely roll over into the following week and get completed during a normal mon-fri.
I'm trying to figure out how to still use the networkdays.intl formula but let Saturday have different hours of operation..
The only thing that comes to mind at this time is that I might need a worksheet with columns for each day of the week and each row is a different date and each cell would contain the maximum number of minutes for that day, and one would have to add up all the cells between a starting and ending date, and then subtract the minutes not present on the last day.. this doesn't seem very practical.
Wondering if anyone has any ideas on what needs to be done.
Thanks!