<div>
Wow that works great, saved me a ton of time!<br />
Thanks
</div>


<div>
<div class="content wysiwyg-content">
I am trying to find the sum of the downtime in format DD:HH:MM:SS<br />
Here is what i currently have:<br />
Totext({#SecondsTotal}/864<wbr />00,'00')<br />
&nbsp;&amp; &quot;:&quot; &amp;<br />
Totext(Remainder({#Seconds<wbr />Total},864<wbr />00) ,'00') <br />
&amp;&nbsp;&quot;:&quot; &amp;<br />
Totext(Remainder({#Seconds<wbr />Total},360<wbr />0),'00') <br />
&amp;&nbsp;&quot;:&quot; &amp;<br />
Totext(Remainder({#Seconds<wbr />Total},60)<wbr />,'00')<br />
<br />
The problem is that it is not rolling up the leftover seconds to the minutes column, hours, and days. &nbsp;<br />
I read somewhere about adding these in but I dont know how to do it.<br />

</div>
</div>


I am trying to find the sum of the downtime in format DD:HH:MM:SS
Here is what i currently have:
Totext({#SecondsTotal}/86400,'00')
 & ":" &
Totext(Remainder({#SecondsTotal},86400) ,'00') 
& ":" &
Totext(Remainder({#SecondsTotal},3600),'00') 
& ":" &
Totext(Remainder({#SecondsTotal},60),'00')

The problem is that it is not rolling up the leftover seconds to the minutes column, hours, and days.  
I read somewhere about adding these in but I dont know how to do it.


Wow that works great, saved me a ton of time!
Thanks

crystal reports sum up date fields in format DD:HH:MM:SS

I am trying to find the sum of the downtime in format DD:HH:MM:SS
Here is what i currently have:
Totext({#SecondsTotal}/86400,&#39;00&#39;)
 &amp; &quot;:&quot; &amp;
Totext(Remainder({#SecondsTotal},86400) ,&#39;00&#39;) 
&amp; &quot;:&quot; &amp;
Totext(Remainder({#SecondsTotal},3600),&#39;00&#39;) 
&amp; &quot;:&quot; &amp;
Totext(Remainder({#SecondsTotal},60),&#39;00&#39;)

The problem is that it is not rolling up the leftover seconds to the minutes column, hours, and days.  
I read somewhere about adding these in but I dont know how to do it.


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.