Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

hencovanee
Contributor II

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

Re: Convert seconds in hours

Try

= your_seconds_field / (60 * 60)

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

MVP
MVP

Re: Convert seconds in hours

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

or

Simply

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

Community Browser