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: 
Anonymous
Not applicable

Convert seconds in hours

Hi all,

In my datasource I have a timefield in seconds. I would like to convert that to hours.

I know how to do it like: 1:30, but in this case I would like to see 1.5 hours. Any ideas?

Kind regards,

Henco

2 Replies
Colin-Albert

Try

= your_seconds_field / (60 * 60)

If this doesn't work, can you post an example of your data.

MK_QSL
MVP
MVP

=Interval(Time(Time#(YourTimeField,'ss'),'hh:mm'))*24

or

Simply

=Interval(Time#(YourTimeField,'ss'))*24