Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

soniasweety
Contributor III

Hour to seconds

Hi all,

I have a field called stage the values is in hours    I want to convert to seconds ?  how can I do this?

Stage (in hrs)      

2

4

45

678

I tried :  stage*3600 as stage    it is not giving the result?

anyone suggest

Thanks

Sonica

Tags (2)
1 Solution

Accepted Solutions

Re: Hour to seconds

May be this

Time(Time#(Stage, 'h'), 'ss') as Stage_Seconds

or Num(Stage) * 3600

3 Replies
sadasiva
Contributor

Re: Hour to seconds

Hi ,

Try with second(stage)  or second(stage*3600) as stage


Re: Hour to seconds

May be this

Time(Time#(Stage, 'h'), 'ss') as Stage_Seconds

or Num(Stage) * 3600

soniasweety
Contributor III

Re: Hour to seconds

thanks sunny I tried secondone

Community Browser