topic Re: Convert seconds in decimal hour in QlikView

Convert seconds in decimal hour

Anonymous — Wed, 12 Jun 2013 10:51:26 GMT

Hi all,

I have a field in the format seconds and I need to put it in a pivot table (I have to sum hours). Convert it to hh: mm: ss is not a problem (sum (Interval (hour_field / (3600 * 24), 'hh: mm: ss')))

but I would like to convert it to decimal hours.

For example, if I have 4 hours and 30 minutes I dont want to see 4.3 but I want to see 4.5. Is it possible?

Thanks!

Re: Convert seconds in decimal hour

sujeetsingh — Wed, 12 Jun 2013 10:58:48 GMT

Hi,

Let the field be TimeSecond then you can easily convert it as

(TimeSecond /3600) it will give you what u want

Re: Convert seconds in decimal hour

Wed, 12 Jun 2013 11:14:43 GMT

see link

hope this helps you

http://community.qlik.com/message/324471

Re: Convert seconds in decimal hour

jagan — Wed, 12 Jun 2013 11:46:59 GMT

Hi,

Try like this

=(Hour('04:30:50') * 60 * 60 + Minute('04:30:50') * 60 + Second('04:30:50')) / (60 * 60)

Use this in you expression or script like this

=(Hour(TimeFieldName) * 60 * 60 + Minute(TimeFieldName) * 60 + Second(TimeFieldName)) / (60 * 60)

Hope this helps you.

Regards,

Jagan.