How do I add time totals ?

[rico7937]

I run a network outage report and it gives me the following information:


Start of Down Time End of Down Time Down Time Total
1/5/2002 02:43:00AM 1/5/2002 02:47:00AM 0:04:0:0

The down time total field is layed out as 0:0:0:0:
1st 0 = days
2nd 0 = hours
3rd 0 = minutes
4th 0 = seconds

How do I come up with a formula that will add the Down Time Total and lay it out in the present status. I need to do a monthly report for January and have about 32 tickets to add
together. Any help is greatly appreciated.
FYI.. Currently running Cystal reports Ver. 7

 

[kmcclung]

Try using this formula....I use for basically the same thing you're trying to do and it works great. Hope it helps!!

WhilePrintingRecords;
NumberVar TotalSecs := Sum {DownTimeTotal}, {Date});
NumberVar Days := Truncate (TotalSec / 86400);
NumberVar Hours := Truncate (Remainder ( TotalSecs,86400) / 3600);
NumberVar Minutes := Truncate (Remainder ( TotalSecs,3600) / 60);
NumberVar Seconds := Remainder ( TotalSecs , 60);

Totext ( Days, '00', 0,'') + ':'+
Totext ( Hours, '00', 0,'') + ':'+
Totext ( Minutes,'00', 0,'') + ':'+
Totext ( Seconds,'00', 0,'')