topic Re: Conversion of hours data column into seconds & taking average of that caliculated column in App Development

Conversion of hours data column into seconds & taking average of that caliculated column

khadar — Thu, 03 Feb 2022 08:51:59 GMT

Hi All,

would some please help on the below query?

I have Feild A from X exceel sheet and Feild B from Y exceel sheet . Date of Feild A is in seconds and Feild B is in HH:MM:SS format. I want to convert bring both either intoFeild A hours or feild B inot hours.

Example:

Feild A

560 seconds

670 seconds

380 seconds

Feild B

00:13:56

00:15:56

07:12:00

Re: Conversion of hours data column into seconds & taking average of that caliculated column

chris_djih — Thu, 03 Feb 2022 14:57:33 GMT

https://community.qlik.com/t5/QlikView-App-Dev/How-to-convert-Duration-in-seconds-to-HH-MM-SS/td-p/841803
Although this is an old qlikview article, the method suggestet holds for qliksense as well.

vor Average see Qlik Help - Avg()