I am trying to figure the date and time difference between two dates. For example the 1st date & time is "12/4/2012 9:10:00AM" 2nd date "12/4/2012 10:10:00AM

These dates are in chronological order and the dates and times change. I am trying to figure out the difference in times and then get an average of time given a specific time period.

 

I was going the path of using a formula below and that is returning negative minutes.

 

DateDiff ("n", {schedule.app_dttm}, previous({schedule.app_dttm})

 

Thanks for the help.