|NETWORKDAYS() function returns the number of whole working days between two dates excluding specified holidays, and it knows nothing about TIME |
Hour and Minute are saved in the integer part of the expression.
No, The integer portion of the number, represents the number of days since 1900-Jan-0.
The Time is the fractional portion of the number, where it represents the fractional portion of a 24 hour day.
So when using NETWORKDAYS() you need to manually separated out the time to do the calculations.
This is an Excel formula and it should have been posted in the Office Software forum.
message edited by mmcconaghy