| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Contradictory results of DateDiff function
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "DATEDIFF" LOCATION IN EXCEL 2007 | Excel Worksheet Functions | |||
| how do you write format results of a function within a function? | Excel Worksheet Functions | |||
| Where is DateDiff function in Excel 2002 ? | Excel Worksheet Functions | |||
| Application.WorkSheetFunction.DafeDif (not DateDiff) | Excel Programming | |||
| DateDiff problem | Excel Programming | |||
Threaded Mode
