Grand total for times 2

[willpp]

got this working and it puts all durations into Hour and minutes so this sorts the first part but then i want to add a grand total for hours and minutes any help would be grateful

First part of formula
local numbervar Hr := Truncate({ADCONT.Duration}/60);
local numbervar Mn := Remainder({ADCONT.Duration},60);
Totext(Hr,0) + "Hr " + ToText(Mn,0) + "m"

 

[Turkbear]

Hi,
Maybe place the Hr and the Mn variables in the report in addition to your formatted formula result - you can supress their display - and then insert a Summary ( Grand Total) for each.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

You need to insert a sum on {ADCONT.Duration} directly and then convert it to the string. Please see faq767-3543 for a method for conversion, and use sum({ADCONT.Duration}) for the "dur" variable.

-LB