|
Re: How to calculate elapsed time? [message #1059143 is a reply to message #1059000] |
Fri, 17 May 2013 00:42 |
|
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.
Michael
Developer Evangelist, Silanis
|
|
|
|
Re: How to calculate elapsed time? [message #1059165 is a reply to message #1059164] |
Fri, 17 May 2013 06:05 |
|
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;
Michael
Developer Evangelist, Silanis
|
|
|
Powered by
FUDForum. Page generated in 0.03646 seconds