Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

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
MVP
MVP

May be this

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

or Num(Stage) * 3600

soniasweety
Master
Master
Author

thanks sunny I tried secondone