Eclipse Community Forums: BIRT » How to calculate elapsed time?

Home » Archived » BIRT » How to calculate elapsed time?

How to calculate elapsed time? [message #1059000]

Thu, 16 May 2013 03:41

Eclipse User

I have tickets with submit date and closed date.
I wish to calculate the total time elapsed between submission and closure of the ticket.
The entries in those columns are in following format:
May 10, 2013 6:15 PM

Also some tickets are not closed so there entries are blank. Also let me know how to calculate for the same.

i want the elapsed time column to appear as a separate column in report.

please help...
and thanks in advance...

Re: How to calculate elapsed time? [message #1059143 is a reply to message #1059000]

Thu, 16 May 2013 20:42

Eclipse User

You should be able to create a computed column and use this function to get the seconds between your two dates:

BirtDateTime.diffSecond(date1,date2)

From there, you can use the elapsed seconds value to display what you'd like.

Re: How to calculate elapsed time? [message #1059164 is a reply to message #1059143]

Fri, 17 May 2013 01:15

Eclipse User

thank you...

can i calculate the time in HH:MM format..as in exact hours and mins...??

Re: How to calculate elapsed time? [message #1059165 is a reply to message #1059164]

Fri, 17 May 2013 02:05

Eclipse User

If you took the seconds from above, you could easily create this format with something like the following as your expression for you type string computed column:

remainingSeconds = BirtDateTime.diffSecond(date1,date2);

Hours = Math.floor(remainingSeconds/3600);
remainingSeconds = remainingSeconds%3600;
Minutes = Math.floor(remainingSeconds/60);
remainingSeconds = remainingSeconds%60;

colOutput = Hours + ":" + Minutes + ":" + remainingSeconds;
colOutput;

Previous Topic:	BIRT ignores alias when generating column binding names for joint data sets
Next Topic:	custom format x-axis and y-axis label in chart by script

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Apr 29 07:40:01 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter