BusinessObjects Board

How to show HH:MM:SS in the column?

Hello All,
I have columns in the reports, which shows time which is displaying value like as


This is a variable we used as below: we want to display HH :MM:SS.

Average Respondtime/Process time.


ktm :us: (BOB member since 2008-11-12)


This old topic can help:

Marek Chladny :slovakia: (BOB member since 2003-11-27)

Hello Marek,

Thanks for your reply,

So, to convert Respondtime which is measure in universe object .I need to use the below formula to determine the number of seconds of Respondtime:

=FormatNumber(Floor([Respondtime]/3600);"00 :") +
FormatNumber(Floor(Mod([Respondtime];3600)/60);"00 :") +

=(ToNumber(FormatDate([Number of seconds];"HH")) * 3600 +
 ToNumber(Left(FormatDate([Number of seconds];"mm:ss") ;2)) * 60 +
 ToNumber(FormatDate([Number of seconds] ;"ss")))

Correct me if i am wrong?

Thanks for your help.


ktm :us: (BOB member since 2008-11-12)

I assume the numbers 5.0,27.0 and 41.0 are in seconds, is that right ? and then you want to show those sec’s as HH:MM:SS ?

If yes, then your first formula is enought to get the time in HH:MM:SS format…

Above formula would return the values as:

Respondtime  Respondtime(HH:MM:SS)
5.0                  00:00:05
27.0                 00:00:27
41.0                 00:00:41

forgotUN (BOB member since 2006-12-13)

Thanks for your reply.

But i want to display the HH:MM:SS in the cell as below:

Respondtime  Respondtime(HH:MM:SS)
5.0                  00HH:00MM:05SS
27.0                 00HH:00MM:27SS
41.0                 00HH:00MM:41SS


ktm :us: (BOB member since 2008-11-12)

This should work

=FormatNumber(Floor([Respondtime]/3600);"00HH:") + 
FormatNumber(Floor(Mod([Respondtime];3600)/60);"00MM:") + 

forgotUN (BOB member since 2006-12-13)


I have similar issue. I’m able to get time in HH:MM:SS format but second does not convert to minute. for example i have 00:02:60, which should be 00:03:00.

Appreciate your help in advance.


moons :us: (BOB member since 2007-11-08)


Can you post the exact formula that you use?

Marek Chladny :slovakia: (BOB member since 2003-11-27)

hi Marek

Can you confirm if it the output is in seconds or minutes or hours?
If in seconds you have to create 4 variables

  1. Hour Mod= Mod((Average Respondtime/Process time);3600)//(will give you reminder)
  2. Hour = ((Average Respondtime/Process time)-[Hour Mod])/3600//(hour)
  3. Minute Mod= Mod(Hour Mod;60)//(Here the reminder is seconds)
  4. Minute = ([Hour Mod]-[Minute Mod])/60 //(Minutes)

then you can use concatenation function as ([Hour]+":"+[Minutes]+":"+[Minutes Mod]).

Hope this will help you

rupakdasatos (BOB member since 2009-07-06)


Some time ago I wrote this formula for converting the number of seconds to HH:MM:SS format:

The formula is for DeskI and it should not be a problem to re-write it for WebI.

Marek Chladny :slovakia: (BOB member since 2003-11-27)