BusinessObjects Board


Hi folks :smiley:

does anybody know a way to display a time as hh:mm:ss?

In Excel I only have to provide the time in fraction of the day and format it as TIME.

0,5 thus is displayed as 12:00:00

Sadly this does not work with BO.

I could start the old game

hh = trunc(day*24)
and then mm and ss with MOD() function and so on. Not very convenient

But hopefully there is somethink like a format function.

Thanks for any help in advance :shock:

OpusDei :de: (BOB member since 2009-08-20)

Check Marek’s suggestion.

Jansi :india: (BOB member since 2008-05-12)

:+1: ok looks pretty much like a solution. Thank you very much. Although I had hoped that some sort of format option could be used.

OpusDei :de: (BOB member since 2009-08-20)

An idea just struck my mind: what if I put the logic in something like a function:

time_char = f()

public function f()
return FormatNumber(Floor(/3600) ,“00”) & “:” &
FormatNumber(Floor(Mod( ,3600)/60) ,“00”) & “:” &
FormatNumber(Mod(Mod( ,3600) ,60) ,“00”)

dono with BO but this is whar I would do by progging

can this be done in Bo?

OpusDei :de: (BOB member since 2009-08-20)


As far as I know, it is possible to create user libraries with functions that can be used in DeskI. But not in WebI.

Check the content of the local folder userlibs.

I have never created such libraries so I can’t help you more but maybe this points you in the right direction.

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