Learn - Convert seconds to HH:MM:SS format in a Business Objects reports

To convert seconds to HH:MM:SS format in a Business Objects reports, you'll need to create a new variable. In this article, we'll share the code you'll need when creating that variable.

Here's the code for a variable to convert the total course duration (seconds) object into hours, minutes and seconds. 

= If ((IsNull([Total Course Duration (seconds)])) Or([Total Course Duration (seconds)] = 0 )) Then ("00:00:00") Else FormatNumber(Floor([Total Course Duration (seconds)] /3600) ;"00") + ":" + FormatNumber(Floor(Mod([Total Course Duration (seconds)] ;3600)/60) ;"00") + ":" + FormatNumber(Mod(Mod([Total Course Duration (seconds)] ;3600) ;60) ;"00")

This code correctly displays the object in HH:MM:SS format instead of seconds.

Get deeper learning in The Academy

Take a tour of the top standard reports in 'Learn LMS: top standard reports and why', for best practice hints and tips to support your learning.

View 'Reporting for beginners' to learn more about reports.

View 'Report building skills' to build your skills. You can also book a space on one of our live ‘Ask me anything: reporting!’ events with our reporting experts. Your opportunity to ask any report questions you have to our experts! 

Have you completed the administrator learning pathway for Learn? Click here to start your learning and to get your trained administrator certificate on completion.

The Academy is your forever free learning hub for Kallidus products including live events, eLearning videos, and more. If you're new to The Academy or know someone who is missing out on free learning, contact your Customer Experience Manager or the Support Team to sign up today!