Format Duration

[former_member731115]

Hello,

I created a report with data from table HistoryJob (columns: Description, RunStart, RunEnd)

I want to calculate the duration with column Duration =RunEnd-RunStart. That works but I cannot format the result like I want.

=Time.formatDuration(RunEnd-RunStart) shows the duration in the format hh:mm:ss.milliseconds

I want the Format hh:mm:ss (without milliseconds).

How can I format the column in the report?

Thanks and best regards

Dana Ullrich

[gmblom · Accepted solution]

Time.formatDurationEx(j.getRunEnd().getUTCMilliSecs() - j.getRunStart().getUTCMilliSecs(), '|1 week, |# weeks, |1 day, |# days, |#|:#|:#||')

[former_member731115 · Accepted solution]

Thank you very much!