To convert value in seconds or decimal value to hr:min:sec

[Former Member]

Hi There,

I got 2 keyfigures which have the same data in decimal and seconds format like 1492.000 or 1492. In the <b>query</b> I want to convert this to HR:MIN:SEC format.

Can anybody help me to convert to hr:min:sec format. what is the formula that can convert this?

Thanks alot

Anima

[Former Member · Accepted solution]

Hi,

you can create a formula using TIME function in the QDesigner.

hope this helps...

Olivier.

Message was edited by:

Olivier Cora

[Former Member · Accepted solution]

The time value which is to be 36:00:00 is displayed as 12:00:00. How do convert this to 36:00:00?

Thanks

[Former Member · Accepted solution]

Hi,

hmmm, I don't have this issue; the system shows me 42:01:23.... could it be user settings in SU01? or even local settings on the user workstation??

let me know...

Olivier.

[Former Member · Accepted solution]

How do you check the settings in SU01 amd local settings?

Thanks alot

[Former Member · Accepted solution]

I checked SU01 and didn't see anything there to customize...

In my workstation, control panel / regional and languages settings / tab regional Options / customize; my time format is HH:mm:ss; the HH has to be in capital letter to display the time in 24 hour...

but this is strange anyway... are you reporting with web frontend or excel?

[Former Member · Accepted solution]

I am using web application designer. when I used the time value in hrminsec format the graph didnt come up