{"id":112,"date":"2023-11-16T08:37:01","date_gmt":"2023-11-16T08:37:01","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/cambiar-formato-de-hora\/"},"modified":"2023-12-25T10:24:01","modified_gmt":"2023-12-25T10:24:01","slug":"cambiar-formato-de-hora","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/cambiar-formato-de-hora\/","title":{"rendered":"\u00bfc\u00f3mo cambiar el formato de hora en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-239863661\"><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>Excel almacena el tiempo como un n\u00famero decimal. (0,412) representa una hora o 1\/24. Y para formatear un valor decimal como hora, tienes dos formas diferentes de hacerlo.<\/p>\n<ul>\n<li> Aplicar el formato de hora en la misma celda.<\/li>\n<li> Crea un nuevo valor de tiempo en las diferentes celdas.<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Cambiar el formato de hora usando un formato personalizado<\/h2>\n<p> En el siguiente ejemplo, tiene un valor decimal en la celda A1 y ahora necesita aplicar el formato de hora a esa celda. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-65994\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-changer-le-format-de-lheure.png\" sizes=\"auto, \" srcset=\"\" alt=\"cambiar formato de hora\" width=\"510\" height=\"340\"><\/figure>\n<\/div>\n<p> Puede utilizar los siguientes pasos para cambiar el formato de hora. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-65995\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-categories-de-temps-sous-les-cellules-de-format.png\" sizes=\"auto, \" srcset=\"\" alt=\"celdas-subformato-categor\u00eda-tiempo\" width=\"570\" height=\"495\"><\/figure>\n<\/div>\n<ol type=\"1\">\n<li> Primero, use el m\u00e9todo abreviado de teclado Crtl+1 para abrir la opci\u00f3n de formato.<\/li>\n<li> Despu\u00e9s de eso, haga clic en la opci\u00f3n de hora de la lista.<\/li>\n<li> Ahora, en el lado derecho del cuadro de di\u00e1logo, seleccione el formato de hora que desea aplicar.<\/li>\n<li> Al final, haga clic en Aceptar para aplicar el formato. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-65996\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-format-dheure-mis-a-jour.png\" sizes=\"auto, \" srcset=\"\" alt=\"formato de hora actualizado\" width=\"487\" height=\"241\"><\/figure>\n<\/div>\n<p> Puede utilizar cualquiera de los formatos de la lista de formatos que tiene en el cuadro de di\u00e1logo de opciones de formato. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-65997\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-listes-de-formats-dheure.png\" sizes=\"auto, \" srcset=\"\" alt=\"formato de lista de tiempo\" width=\"431\" height=\"291\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Utilice la funci\u00f3n TEXTO para cambiar el formato de hora<\/h2>\n<p> En Excel hay una funci\u00f3n de TEXTO que puedes usar para cambiar el formato de hora y obtenerlo en una nueva celda con un nuevo formato. En el siguiente ejemplo, tiene un valor decimal en la celda A1.<\/p>\n<p> Y para cambiar el formato de hora, debe utilizar la funci\u00f3n TEXTO. Puede utilizar los siguientes pasos: <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-65998\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-fonction-de-texte-pour-le-changement-de-format-dheure.png\" sizes=\"auto, \" srcset=\"\" alt=\"funci\u00f3n-de-texto-para-cambio-de-formato-de-hora\" width=\"487\" height=\"259\"><\/figure>\n<\/div>\n<ol type=\"1\">\n<li> Primero, en la celda B1, ingrese la funci\u00f3n de texto (=TEXTO).<\/li>\n<li> Despu\u00e9s de eso, consulte la celda A1.<\/li>\n<li> Luego, en el segundo argumento, especifica el formato que deseas aplicar en ese momento. Aqu\u00ed usamos (hh:mm AM\/PM).<\/li>\n<li> Al final, ingrese el par\u00e9ntesis de cierre y presione Enter para obtener el resultado. <\/li>\n<\/ol>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXT(A1,\"hh:mm AM\/PM\")<\/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\/changer-le-format-de-lheure-2.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<div class=\"wp-block-columns is-layout-flex wp-container-3\">\n<div class=\"wp-block-column is-layout-flow\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/agregar-horas-en-el-tiempo\/\">Agregar horas al tiempo en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/agregar-minutos-al-tiempo\/\">Agregar minutos al tiempo en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/calcular-la-diferencia-horaria\/\">Diferencia entre dos tiempos en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/tiempo-militar\/\">Hora militar (obtener y restar) en Excel<\/a><\/li>\n<\/ul>\n<\/div>\n<div class=\"wp-block-column is-layout-flow\">\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<\/ul>\n<\/div>\n<\/div>\n<p> \u21e0 Volver a <a href=\"https:\/\/exceladvisor.org\/es\/formulas\/\">la lista de m\u00e1s de 100 f\u00f3rmulas de Excel (b\u00e1sicas + avanzadas)<\/a><\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Excel almacena el tiempo como un n\u00famero decimal. (0,412) representa una hora o 1\/24. Y para formatear un valor decimal como hora, tienes dos formas diferentes de hacerlo. Aplicar el formato de hora en la misma celda. Crea un nuevo valor de tiempo en las diferentes celdas. Cambiar el formato de hora usando un formato [&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-112","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 cambiar el formato de hora en excel?<\/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\/cambiar-formato-de-hora\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo cambiar el formato de hora en excel?\" \/>\n<meta property=\"og:description\" content=\"Excel almacena el tiempo como un n\u00famero decimal. (0,412) representa una hora o 1\/24. Y para formatear un valor decimal como hora, tienes dos formas diferentes de hacerlo. Aplicar el formato de hora en la misma celda. Crea un nuevo valor de tiempo en las diferentes celdas. Cambiar el formato de hora usando un formato [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/cambiar-formato-de-hora\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:24:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-changer-le-format-de-lheure.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\/cambiar-formato-de-hora\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/cambiar-formato-de-hora\/\",\"name\":\"\u00bfc\u00f3mo cambiar el formato de hora en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/cambiar-formato-de-hora\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/cambiar-formato-de-hora\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-changer-le-format-de-lheure.png\",\"datePublished\":\"2023-11-16T08:37:01+00:00\",\"dateModified\":\"2023-12-25T10:24:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/cambiar-formato-de-hora\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/cambiar-formato-de-hora\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/cambiar-formato-de-hora\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-changer-le-format-de-lheure.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-changer-le-format-de-lheure.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/cambiar-formato-de-hora\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo cambiar el formato de hora en excel?\"}]},{\"@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 cambiar el formato de hora en excel?","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\/cambiar-formato-de-hora\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo cambiar el formato de hora en excel?","og_description":"Excel almacena el tiempo como un n\u00famero decimal. (0,412) representa una hora o 1\/24. Y para formatear un valor decimal como hora, tienes dos formas diferentes de hacerlo. Aplicar el formato de hora en la misma celda. Crea un nuevo valor de tiempo en las diferentes celdas. Cambiar el formato de hora usando un formato [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/cambiar-formato-de-hora\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:24:01+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-changer-le-format-de-lheure.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\/cambiar-formato-de-hora\/","url":"https:\/\/exceladvisor.org\/es\/cambiar-formato-de-hora\/","name":"\u00bfc\u00f3mo cambiar el formato de hora en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/cambiar-formato-de-hora\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/cambiar-formato-de-hora\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-changer-le-format-de-lheure.png","datePublished":"2023-11-16T08:37:01+00:00","dateModified":"2023-12-25T10:24:01+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/cambiar-formato-de-hora\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/cambiar-formato-de-hora\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/cambiar-formato-de-hora\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-changer-le-format-de-lheure.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-changer-le-format-de-lheure.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/cambiar-formato-de-hora\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo cambiar el formato de hora en excel?"}]},{"@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\/112","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=112"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/112\/revisions"}],"predecessor-version":[{"id":892,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/112\/revisions\/892"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}