Using DateDiff() Function in ArcGIS Field Calculator

Discussion created by rmwolter on Apr 18, 2014
Latest reply on Apr 18, 2014 by rmwolter
I am trying to calculate the time difference between two fields using the DateDiff() function in minutes. I have successfully calculated the times that fall within the same day but I am having trouble with the times that are occurring in day transition (after 11:59 PM). For example: My date fields are as such,

MM\dd\yyyy hh:mm:ss tt

So between these two times

01\17\2007 11:57:08 PM and 01\18\2007 12:15:01 AM

The field calculator would apply a huge negative number. I am thinking a conditional statement is needed for basic arithmetic but am at a loss.

Please be as detailed as possible. I am not a developer.