Net Work Days
Recreates the NETWORKDAYS function from Excel with some bonus measures and one that needs fixed or demonstrates a bug/documentation glitch.
NetWorkDays calculates the number of days between two...
Greg_Deckler Sorry for dredging up this old thread, but I have the following question:
When I use the NetWorkDaysHolidaysDaysHoursMinutes formula, I can get values like:
4 Days 19 Hours 28 Minutes
Though I'd like to measure the hours and minutes only when the office is open. Can you maybe send me in the right direction how someone would tackle this problem?
Thanks in advance!