Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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

1 Solution

Accepted Solutions
sunny_talwar

May be this

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

or Num(Stage) * 3600

View solution in original post

3 Replies
Anonymous
Not applicable

Hi ,

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


sunny_talwar

May be this

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

or Num(Stage) * 3600

soniasweety
Master
Master
Author

thanks sunny I tried secondone