Open Time Resolve Time Mean Date/Time To Resolve
2/1/2008 1:18 2/5/2008 7:14
2/1/2008 1:01 2/1/2008 1:01
2/1/2008 1:02 2/12/2008 11:39
2/1/2008 1:03 2/2/2008 6:58
2/1/2008 1:06 2/1/2008 3:02
2/1/2008 2:01 2/1/2008 2:02
2/1/2008 2:17 2/1/2008 4:10
2/1/2008 2:41 2/2/2008 1:11
2/1/2008 2:43 2/1/2008 4:50
2/1/2008 2:43 2/1/2008 2:45
2/1/2008 3:22 2/1/2008 11:24
2/1/2008 4:25 2/1/2008 12:58
2/1/2008 3:27 2/1/2008 9:54
2/1/2008 3:56 2/1/2008 13:16
2/1/2008 4:01 2/1/2008 4:09
2/1/2008 4:08 2/1/2008 4:25
2/1/2008 5:22 2/1/2008 5:32
2/1/2008 5:24 2/20/2008 10:46
2/1/2008 5:44 2/1/2008 17:22
I would like to measure the date/time difference from the "Open Time" to the "Resolve Time" and put the data in a new column(Mean Date/Time To Resolve).
As you can see some of the records have days bewteen them.
2/1/2008 1:18 2/5/2008 7:14
2/1/2008 1:01 2/1/2008 1:01
2/1/2008 1:02 2/12/2008 11:39
2/1/2008 1:03 2/2/2008 6:58
2/1/2008 1:06 2/1/2008 3:02
2/1/2008 2:01 2/1/2008 2:02
2/1/2008 2:17 2/1/2008 4:10
2/1/2008 2:41 2/2/2008 1:11
2/1/2008 2:43 2/1/2008 4:50
2/1/2008 2:43 2/1/2008 2:45
2/1/2008 3:22 2/1/2008 11:24
2/1/2008 4:25 2/1/2008 12:58
2/1/2008 3:27 2/1/2008 9:54
2/1/2008 3:56 2/1/2008 13:16
2/1/2008 4:01 2/1/2008 4:09
2/1/2008 4:08 2/1/2008 4:25
2/1/2008 5:22 2/1/2008 5:32
2/1/2008 5:24 2/20/2008 10:46
2/1/2008 5:44 2/1/2008 17:22
I would like to measure the date/time difference from the "Open Time" to the "Resolve Time" and put the data in a new column(Mean Date/Time To Resolve).
As you can see some of the records have days bewteen them.