<div>
Sp you are suggesting to convert both into seconds and number values<br />
perform the deducton and then calculate hours / mins / seconds as a text field.<br />
Thanks<br />
&nbsp;<br />
R<br />

</div>


Sp you are suggesting to convert both into seconds and number values
perform the deducton and then calculate hours / mins / seconds as a text field.
Thanks
 
R


<div>
This worked really well.<br />
Please accept my apologies. I had not seen it not accepted.<br />
Sorry for the late close<br />
&nbsp;<br />
Romolo<br />

</div>


This worked really well.
Please accept my apologies. I had not seen it not accepted.
Sorry for the late close
 
Romolo


<div>
<div class="content wysiwyg-content">
Hey<br />
<br />
My report required totalling time values past 24 hours and the source field is varchar sql 2000 8 characters and allows nulls.<br />
<br />
I will have values listed 3 or 4 records of 99:00:00.<br />
<br />
I need to total these records and then deduct a time value that I have pulled from a subreport.<br />
<br />
There will also be a record that will have a null in this field in addition to the ones I wish to sum.<br />
<br />
Total time - Time Used.<br />
<br />
287:00:00<br />
or 287:30:00<br />
<br />
deduct 125:30:00<br />
<br />
ALSO if you can answer separately how can crystal actually store timevalues larger than 23:59:59.<br />
<br />
My current deduction value is only 15 hours for this test. But will immediately need to store larger.<br />
<br />
Many thanks in advance<br />
<br />
R
</div>
</div>


Hey

My report required totalling time values past 24 hours and the source field is varchar sql 2000 8 characters and allows nulls.

I will have values listed 3 or 4 records of 99:00:00.

I need to total these records and then deduct a time value that I have pulled from a subreport.

There will also be a record that will have a null in this field in addition to the ones I wish to sum.

Total time - Time Used.

287:00:00
or 287:30:00

deduct 125:30:00

ALSO if you can answer separately how can crystal actually store timevalues larger than 23:59:59.

My current deduction value is only 15 hours for this test. But will immediately need to store larger.

Many thanks in advance

R

Crystal Reports Totalling time and deducting time used.

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.