Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to get Sum for my Elapse Time string for my group

Hi,

How can I get the sum of an elapse time string in my group footer 2 and group footer 1 from the report screenshot attached.

I have a report that display TimeIn and TimeOut of an employee.

For the total time I have created a formula that will take my time in seconds and displaying it in hrs, minutes and seconds.

How can I get the sum of all the total time per day and display this in my group footer 2.

As well I will need to add the grand total to group footer 1 for the total of days.

The formula I have for the total time is as follow:

WhileReadingRecords;

NumberVar TotalSec :=  {TimeLogs.TotalTime};

NumberVar Hours   := Truncate  (Remainder ( TotalSec , 86400) / 3600) ;

NumberVar Minutes := Truncate  (Remainder ( TotalSec , 3600) / 60) ;

NumberVar Seconds := Remainder (TotalSec , 60) ;

Totext ( Hours ,   '00' ) +  ':' +

Totext ( Minutes , '00' ) +  ':' +

Totext ( Seconds , '00' )

--------------------------------------------------------------------------------

This is a seperate question below but related as well to this report.

Another question I have is how can I round up for example 03:30:58 to 03:31:00

And also how can I round down for example 03:26:10 to 03:26:00

Any help would be appreciated.

Thank you,

Joe

CR Elapse Time.PNG (57185 B)
Former Member
replied

hi Jocelyn,

if you put your  {TimeLogs.TotalTime} field on your report, right click on it and choose Insert > Summary and then leave it as type = Sum and then have it inserted on the desired group level.

now right click on the new Summary and choose Format Field > Common tab > Display string and enter this syntax

numbervar ts:= currentfieldvalue;
totext(dateadd("s",ts,currentdate),'HH:mm:ss');

for the second question please post a new discussion as per the forum rules.

-jamie

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question