{"id":237,"date":"2023-11-10T09:45:03","date_gmt":"2023-11-10T09:45:03","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/"},"modified":"2023-12-25T10:24:52","modified_gmt":"2023-12-25T10:24:52","slug":"segundos-a-horas-minutos","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/","title":{"rendered":"\u00bfc\u00f3mo convertir segundos a horas y minutos?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2181493531\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>Para convertir segundos a horas o minutos en Excel, debes dividir el valor de segundos que tienes por la cantidad total de segundos que tienes en un solo d\u00eda. Despu\u00e9s de eso, debes cambiar el formato a horas y minutos. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80514\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png\" sizes=\"auto, \" srcset=\"\" alt=\"convertir segundos a horas y minutos\" width=\"583\" height=\"268\"><\/figure>\n<\/div>\n<p> En este tutorial, aprender\u00e1 a escribir y comprender estas f\u00f3rmulas en detalle. Para su referencia, en el siguiente ejemplo tiene 10000 segundos en la celda A1. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80515\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-secondes-comme-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"segundo como valor\" width=\"433\" height=\"194\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Convertir segundos a horas (hh:mm:ss)<\/h2>\n<p> Estos son los pasos para escribir esta f\u00f3rmula:<\/p>\n<ol>\n<li> Primero, en una celda, ingresa la f\u00f3rmula para dividir segundos entre 86400 (el n\u00famero total de segundos en un d\u00eda). <br \/><img loading=\"lazy\" decoding=\"async\" title=\"3-divisiones-de-segundos\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-diviser-les-secondes.png\" sizes=\"auto, \" srcset=\"\" alt=\"divide-the-seconds\" width=\"515\" height=\"262\"><\/li>\n<li> Despu\u00e9s de eso, abra <a href=\"https:\/\/exceladvisor.org\/es\/opciones-de-celda-de-formato-abierto\/\">Opciones de formato (Ctrl+1)<\/a> . <br \/><img loading=\"lazy\" decoding=\"async\" title=\"formato abierto de 4 celdas\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-cellules-au-format-ouvert.png\" sizes=\"auto, \" srcset=\"\" alt=\"open-format-cells\" width=\"513\" height=\"358\"><\/li>\n<li> Ahora, en la lista de categor\u00edas, haga clic en \u201cPersonalizado\u201d. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"5-seleccionar-categor\u00eda-personalizada\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-selectionnez-la-categorie-personnalisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-custom-category\" width=\"596\" height=\"323\"><\/li>\n<li> Luego, en la barra de entrada de texto, ingrese [hh]:mm o [hh]:mm:ss. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"Valor personalizado de 6 entradas\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-entrez-la-valeur-personnalisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-custom-value\" width=\"593\" height=\"290\"><\/li>\n<li> Al final, haga clic en Aceptar para aplicar el formato.<\/li>\n<\/ol>\n<p> Cuando presionas OK, te da el n\u00famero total de horas y minutos. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80520\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-nombre-total-dheures-et-de-minutes.png\" sizes=\"auto, \" srcset=\"\" alt=\"n\u00famero-total-de-horas-y-minutos\" width=\"475\" height=\"238\"><\/figure>\n<\/div>\n<p class=\"grey-note\"> <strong>En lugar de usar hh:mm:ss, aqu\u00ed usamos [hh]:mm o [hh]:mm:ss.<\/strong><\/p>\n<p class=\"grey-note\"> Porque cuando usas hh:mm y tienes segundos mayores que el n\u00famero total de segundos en un d\u00eda, obtendr\u00e1s un mal resultado.<\/p>\n<p class=\"grey-note\"> Si tienes 27 horas te dir\u00e1 3 horas pasando las 24 horas diarias. Es por eso que deber\u00edas usar [hh]:mm:ss y [hh]:mm.<\/p>\n<h2 class=\"wp-block-heading\"> Convertir segundos a minutos<\/h2>\n<p> De la misma manera, puedes convertir segundos a minutos, debes seguir los mismos pasos, pero debes usar un formato personalizado diferente. Una vez que ingrese la f\u00f3rmula en la celda, cambie el formato a [mm]:ss y haga clic en Aceptar. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80521\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-convertir-des-secondes-en-minutes.png\" sizes=\"auto, \" srcset=\"\" alt=\"convertir segundos a minutos\" width=\"782\" height=\"338\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Uso de la funci\u00f3n de texto para convertir segundos en horas y minutos<\/h2>\n<p> S\u00ed, tambi\u00e9n puedes utilizar la funci\u00f3n TEXTO. Esto permite la conversi\u00f3n de segundos al resultado deseado sin cambiar el formato de la celda. En la funci\u00f3n TEXTO, puede especificar el formato dentro de la funci\u00f3n. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80522\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-fonctions-de-texte-pour-convertir-les-secondes.png\" sizes=\"auto, \" srcset=\"\" alt=\"funci\u00f3n-de-texto-para-convertir-segundos\" width=\"606\" height=\"228\"><\/figure>\n<\/div>\n<p> En el primer argumento de TEXTO, debes ingresar la misma f\u00f3rmula segundos\/segundos totales en un d\u00eda. Despu\u00e9s de eso, en el segundo argumento (text_format), ingresa el formato que deseas dar.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXT(A1\/86400,\"[hh]:mm\") =TEXT(A1\/86400,\"[mm]:ss\")<\/code><\/pre>\n<div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\">\n<h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtener el archivo Excel<\/h2>\n<p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/convertir-les-secondes.xlsx\" rel=\"nofollow\">Descargar<\/a> <\/p>\n<\/div>\n<div class=\"wp-block-group more-tutorials is-layout-flow\">\n<div class=\"wp-block-group__inner-container\">\n<h2 class=\"wp-block-heading\"> M\u00e1s f\u00f3rmulas<\/h2>\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/tiempo-en-minutos-2\/\">Convertir el valor del tiempo a minutos (f\u00f3rmula de Excel)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/tiempo-en-segundos-2\/\">Convertir el valor del tiempo a segundos<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/hora-actual-2\/\">Obtener la hora actual (f\u00f3rmula de Excel)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/hora-de-la-siesta-2\/\">Suma de tiempo en Excel (f\u00f3rmula de Excel)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/agregar-segundos-al-tiempo\/\">A\u00f1adir segundos al tiempo<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Para convertir segundos a horas o minutos en Excel, debes dividir el valor de segundos que tienes por la cantidad total de segundos que tienes en un solo d\u00eda. Despu\u00e9s de eso, debes cambiar el formato a horas y minutos. En este tutorial, aprender\u00e1 a escribir y comprender estas f\u00f3rmulas en detalle. Para su referencia, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-237","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfc\u00f3mo convertir segundos a horas y minutos?<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo convertir segundos a horas y minutos?\" \/>\n<meta property=\"og:description\" content=\"Para convertir segundos a horas o minutos en Excel, debes dividir el valor de segundos que tienes por la cantidad total de segundos que tienes en un solo d\u00eda. Despu\u00e9s de eso, debes cambiar el formato a horas y minutos. En este tutorial, aprender\u00e1 a escribir y comprender estas f\u00f3rmulas en detalle. Para su referencia, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:24:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/\",\"name\":\"\u00bfc\u00f3mo convertir segundos a horas y minutos?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png\",\"datePublished\":\"2023-11-10T09:45:03+00:00\",\"dateModified\":\"2023-12-25T10:24:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo convertir segundos a horas y minutos?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo convertir segundos a horas y minutos?","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo convertir segundos a horas y minutos?","og_description":"Para convertir segundos a horas o minutos en Excel, debes dividir el valor de segundos que tienes por la cantidad total de segundos que tienes en un solo d\u00eda. Despu\u00e9s de eso, debes cambiar el formato a horas y minutos. En este tutorial, aprender\u00e1 a escribir y comprender estas f\u00f3rmulas en detalle. Para su referencia, [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:24:52+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/","url":"https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/","name":"\u00bfc\u00f3mo convertir segundos a horas y minutos?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png","datePublished":"2023-11-10T09:45:03+00:00","dateModified":"2023-12-25T10:24:52+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/segundos-a-horas-minutos\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo convertir segundos a horas y minutos?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/237","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=237"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/237\/revisions"}],"predecessor-version":[{"id":969,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/237\/revisions\/969"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}