Network days rounding off hours
hi
any update on this, i m still left without clue , Bob u ther?
Rgds
TT
"Thomas T" wrote:
Hi Bob
Sorry for the delay in reply..
This would be 2,which is correct
but the problem can be explained better, if we take another example,
start time is 21/02/2008 10:47:00 PM
end time is 22/02/2008 9:19:00 PM
clearly it is within 24 hours, but networkdays will show it as 2nd day,
I think the problem is that networkdays(A1,A2) is rounding off beyond 12
hours into the next day..
so getting 2 instead of 1 and my happiness is tossed.....
TT
|