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