ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Average of a difference between 2 cels in a table/array (https://www.excelbanter.com/excel-worksheet-functions/195470-average-difference-between-2-cels-table-array.html)

GCRDelphi

Average of a difference between 2 cels in a table/array
 
Hello,

I have the following columns:

A=Issue # B=User C=Issue D=Issue Date E=Start Date F=End Date

I want to create a table (for creating a graph) of the average per month if
the gap in days between column C and each of D E and F, for exmaple take an
everage of all the month of the results of Date in D - Date in C, and in the
next row E - C, etc.

Thank you for your help.
--
Gabriel Camarena R.
Delphi Tijuana IT Support


All times are GMT +1. The time now is 09:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com