https://community.qlik.com/t5/Data-Movement-Streaming/Convertir-segundos-a-MM-SS/m-p/2136671#M1560 <P>Los datos son dias en Qlik:<BR /><FONT face="courier new,courier">Time(Date(<SPAN>averageSessionDuration/86400)</SPAN></FONT></P> Fri, 10 Nov 2023 10:58:00 GMT vincent_ardiet_ 2023-11-10T10:58:00Z https://community.qlik.com/t5/Data-Movement-Streaming/Convertir-segundos-a-MM-SS/m-p/2136655#M1557 <P>Buenas,</P> <P>Tengo un formato de datos recogidos con Google Analytics y me los genera en segundos, pero yo los quiero convertir a formato MM:SS.</P> <P>Este es el formato:</P> <TABLE class="awsui_table_wih1l_1l1xk_144" role="table" aria-rowcount="100" aria-labelledby="heading65-1699610617391-2661"> <TBODY> <TR class="awsui_row_wih1l_1l1xk_301" data-selection-item="item" aria-rowindex="2"> <TD class="awsui_body-cell_c6tup_t94xq_93 awsui_body-cell-first-row_c6tup_t94xq_145">&nbsp;</TD> </TR> <TR class="awsui_row_wih1l_1l1xk_301" data-selection-item="item" aria-rowindex="3"> <TD class="awsui_body-cell_c6tup_t94xq_93">2</TD> <TD class="awsui_body-cell_c6tup_t94xq_93"> <DIV class="whitespace-pre hidden-overflow-ellipsis">13/08/</DIV> </TD> <TD class="awsui_body-cell_c6tup_t94xq_93"> <DIV class="whitespace-pre hidden-overflow-ellipsis">averageSessionDuration</DIV> </TD> <TD class="awsui_body-cell_c6tup_t94xq_93"> <DIV class="whitespace-pre hidden-overflow-ellipsis">110.12393722222221</DIV> </TD> </TR> <TR class="awsui_row_wih1l_1l1xk_301" data-selection-item="item" aria-rowindex="4"> <TD class="awsui_body-cell_c6tup_t94xq_93">3</TD> <TD class="awsui_body-cell_c6tup_t94xq_93"> <DIV class="whitespace-pre hidden-overflow-ellipsis">14/09/</DIV> </TD> <TD class="awsui_body-cell_c6tup_t94xq_93"> <DIV class="whitespace-pre hidden-overflow-ellipsis">averageSessionDuration</DIV> </TD> <TD class="awsui_body-cell_c6tup_t94xq_93"> <DIV class="whitespace-pre hidden-overflow-ellipsis">158.13628633619865</DIV> </TD> </TR> <TR class="awsui_row_wih1l_1l1xk_301" data-selection-item="item" aria-rowindex="5"> <TD class="awsui_body-cell_c6tup_t94xq_93">4</TD> <TD class="awsui_body-cell_c6tup_t94xq_93"> <DIV class="whitespace-pre hidden-overflow-ellipsis">05/11/</DIV> </TD> <TD class="awsui_body-cell_c6tup_t94xq_93"> <DIV class="whitespace-pre hidden-overflow-ellipsis">averageSessionDuration</DIV> </TD> <TD class="awsui_body-cell_c6tup_t94xq_93"> <DIV class="whitespace-pre hidden-overflow-ellipsis">129.51163411627908</DIV> </TD> </TR> <TR class="awsui_row_wih1l_1l1xk_301" data-selection-item="item" aria-rowindex="6"> <TD class="awsui_body-cell_c6tup_t94xq_93">5</TD> <TD class="awsui_body-cell_c6tup_t94xq_93"> <DIV class="whitespace-pre hidden-overflow-ellipsis">08/08/</DIV> </TD> <TD class="awsui_body-cell_c6tup_t94xq_93"> <DIV class="whitespace-pre hidden-overflow-ellipsis">averageSessionDuration</DIV> </TD> <TD class="awsui_body-cell_c6tup_t94xq_93"> <DIV class="whitespace-pre hidden-overflow-ellipsis">217.155807150079</DIV> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Como podria convertirlos a este formato?&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="migueldfr_23_0-1699612117488.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/119722iC3BABA207B8AA82B/image-size/medium?v=v2&amp;px=400" role="button" title="migueldfr_23_0-1699612117488.png" alt="migueldfr_23_0-1699612117488.png" /></span></P> <P>&nbsp;</P> <P>Muchas gracias de antemano por la ayuda</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 19 Mar 2025 22:43:16 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Convertir-segundos-a-MM-SS/m-p/2136655#M1557 migueldfr_23 2025-03-19T22:43:16Z https://community.qlik.com/t5/Data-Movement-Streaming/Convertir-segundos-a-MM-SS/m-p/2136667#M1558 <P>Hola,</P> <P>La unidad de tiempo es el día, así que si aplicas Time(averageSessionDuration/60/60/24) debería devolverte el formato correcto.</P> <P>Por informar que hay un foro dedicado a consultas en español/castellano:&nbsp;<A href="https://community.qlik.com/t5/Espa%C3%B1ol/gh-p/spanish-group" target="_blank">https://community.qlik.com/t5/Espa%C3%B1ol/gh-p/spanish-group</A></P> <P>Saludos.</P> Fri, 10 Nov 2023 10:56:11 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Convertir-segundos-a-MM-SS/m-p/2136667#M1558 rubenmarin 2023-11-10T10:56:11Z https://community.qlik.com/t5/Data-Movement-Streaming/Convertir-segundos-a-MM-SS/m-p/2136670#M1559 <P>Muchas gracias, lo probaré.<BR />Y también te agradezco que me hayas pasado ese foro en español.</P> Fri, 10 Nov 2023 10:57:58 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Convertir-segundos-a-MM-SS/m-p/2136670#M1559 migueldfr_23 2023-11-10T10:57:58Z https://community.qlik.com/t5/Data-Movement-Streaming/Convertir-segundos-a-MM-SS/m-p/2136671#M1560 <P>Los datos son dias en Qlik:<BR /><FONT face="courier new,courier">Time(Date(<SPAN>averageSessionDuration/86400)</SPAN></FONT></P> Fri, 10 Nov 2023 10:58:00 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Convertir-segundos-a-MM-SS/m-p/2136671#M1560 vincent_ardiet_ 2023-11-10T10:58:00Z