BusinessObjects Board

Convert a numeric field to HH:mm:ss


I work on the new Web 4.0. I have a numeric field containing the amount of secunds of a certain dimension. I would like to display the field as hh:mm:ss. For example 74 to be shown as 00:01:14

I know i should push this function to the universe or the dbse server (Microsoft actually) but there are a lot of calculation that have to be done in WebI…

In advance thank´s for many ansvers!


olalav (BOB member since 2008-10-27)


Try a formula from this old topic:

You need to convert the syntax from DeskI to WebI, should be simple.

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

Thank’s for your answer! I already found this one earlier but did not manage the conversion to WebI 4.0!

I’ll try again!


olalav (BOB member since 2008-10-27)