cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos
101

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

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

hope this helps...

Olivier.

Message was edited by:

Olivier Cora

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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

Thanks alot

Former Member
0 Kudos

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
0 Kudos

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

Answers (0)