Accumulate Time Values

[harding1031]

CR 9.0
I currently have a report that displays start time, stop time, and time processing, which is the difference between the start and stop time. I am trying to get a total time process, but everything I try I come up short.
start stop time processing
11:00 11:30 :30
12:00 13:00 1:00

total: 1:30
I can not seem to sum up the time processing field(it is defined as time field). TIA.

 

[lbass]

Create a formula:

datediff("s",datetime(date(0,0,0),{table.starttime}),datetime(date(0,0,0),{table.stoptime}))

Using SynapseVampire's FAQ767-3543, plug the seconds value into the following formula as shown:

numberVar dur := datediff("s",datetime(date(0,0,0),{table.starttime}),datetime(date(0,0,0),{table.stoptime}));
numberVar hrs;
numberVar min;
numberVar sec;
stringVar hhmmss;

hrs := Truncate(Truncate(dur/60)/60);
min := Remainder(Truncate(dur/60),60);
sec := Remainder(dur,60);

hhmmss := totext(hrs, "0") + ":" + totext(min, "00") + ":" + totext(sec, "00");

hhmmss

If you have a date field, I would use that in the formula instead of date(0,0,0)--to allow for time diffs that cross days.

-LB

 

[harding1031]

Thanks, I'll give it a shot!!!!