Network days rounding off hours
hi all
found the solution
IF(((VALUE(RIGHT(L2,9))*1440/60)-(VALUE(RIGHT(H2,9))*1440/60))=0,NETWORKDAYS(L2,H2)-1,NETWORKDAYS(L2,H2))
exception is for 1 day where i used an if condition to give 1,
Regards
TT
"Thomas T" wrote:
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
|