Thread: Timestamp ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
elroyerni elroyerni is offline
external usenet poster
 
Posts: 1
Default Timestamp ?

Hi -

I run a query in oracle and import the results into excel. What I'm
looking to do is create a column in excel with the avg of the
timestamps. For example:

CRAT_TSP RESOL_DTE
05/27/2007 07:50:19 05/27/2007 07:50:34
05/27/2007 07:50:19 05/27/2007 07:50:38
05/27/2007 07:53:24 05/27/2007 07:53:38

I want to subtract the resolved minus created timestamp and create a
column with the average it took for it to complete. Can someone point
me in the right direction?

THANKS!!