BusinessObjects Board

Time Format

building reports desktopintelligence
#1

Hai,

How can I convert a Number to Time Format in BO 6.5 Full Client ?

I have an object (average_time) which retreives the number values , for ex 10,30,etc.

How Can I convert these into HH24:MI:SS format in the Report?

I have to use this variable in another variable ,so some conversion has to be done.

Can Any one pls provide some suggestions to this.

Thanks

Sai.

Sai2255 :india: (BOB member since 2007-05-15)

Formula for separate time from seconds needed
Display seconds as HH:MM
Convertion of Hours into HH:MM:SS in deski 6.5
Display time duratoin in hours over 24
#2

can you explain the problem in detail.

ay1224 :us: (BOB member since 2007-07-30)

#3

Hi,

If the number you have represents the number of seconds and you want to format it to hh:mm:ss format then use the following formula:

=FormatNumber(Floor(<number of seconds>/3600) ,"00") &amp; ":" &amp;
FormatNumber(Floor(Mod(<number of seconds> ,3600)/60) ,"00") &amp; ":" &amp;
FormatNumber(Mod(Mod(<number of seconds> ,3600) ,60) ,"00")

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

#4

Thanks Very Much Marek.It works fine.

Sai2255 :india: (BOB member since 2007-05-15)