are you really different results for the same values?

From XL/VBA Help:

If date1 refers to a later point in time than date2, the DateDiff function
returns a negative number.



In article ,
"Pallavi Singh" wrote:

Hello,
Could anyone plz point out that what could be the probable reason for
DateDiff function to give different answers for the same set of values.
I am using the following:
DateDiff ( "s", time1, time2)
Here 'time1' is greater than 'time2'. But the DateDiff function
sometimes returns a positive value and sometimes a negative value.
Thanks in advance,
Pallavi