<div>
have you tried something like<br />
Average({Jobs.TimeSpend})
</div>


have you tried something like
Average({Jobs.TimeSpend})

<div>
Hi,<br />
<br />
I believe you will have multiple jobs for each fitter. If so, you can create a group on fitter DB field and insert summary and select &quot;Average&quot; under &quot;Calculate This Summary&quot; dropdown and select the newly created group under &quot;Summary Location&quot;.<br />
<br />
Hope that helps.
</div>


Hi,

I believe you will have multiple jobs for each fitter. If so, you can create a group on fitter DB field and insert summary and select "Average" under "Calculate This Summary" dropdown and select the newly created group under "Summary Location".

Hope that helps.

<div>
You may have to calculate the time in seconds then do the average and convert it for display<br />
<br />
mlmcc
</div>


You may have to calculate the time in seconds then do the average and convert it for display

mlmcc

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I need help please to find out the &nbsp;average time for a fitter on his jobs<br />
Start time &nbsp; &nbsp; &nbsp; End time &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Time spend<br />
&nbsp;11:14:26 &nbsp; &nbsp; &nbsp; &nbsp; 11:17:11 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;00:02:45 <br />
&nbsp;14:17:00 &nbsp; &nbsp; &nbsp; &nbsp; 09:58:17 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;19:41:17 <br />
&nbsp;08:51:39 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;09:45:24 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 00:53:45 <br />
<br />
Please can you help me as I need to find the average time spend in crytal reports
</div>
</div>


Hi,

I need help please to find out the  average time for a fitter on his jobs
Start time       End time           Time spend
 11:14:26         11:17:11            00:02:45 
 14:17:00         09:58:17            19:41:17 
 08:51:39          09:45:24           00:53:45 

Please can you help me as I need to find the average time spend in crytal reports

Calculate Avearge time per user

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.