Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I have the following data in the following columns in Excel

Status
Not open for further replies.

kre1973

IS-IT--Management
May 5, 2006
47
US
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.

 
Create a formula like this {@mins}:

datediff("n",{table.opentime},{table.resolvetime})

This will return the difference in minutes. You can convert the result to a string representing days, hours, minutes by using faq767-3543.

You didn't explain the "mean". If you need the average across all records, then insert an average on {@mins} and then use the faq to convert the results.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top