{"id":231,"date":"2023-11-10T17:00:39","date_gmt":"2023-11-10T17:00:39","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/hora-actual-2\/"},"modified":"2023-12-25T10:26:26","modified_gmt":"2023-12-25T10:26:26","slug":"hora-actual-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/hora-actual-2\/","title":{"rendered":"\u00bfc\u00f3mo obtener la hora actual en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1537693305\"><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 obtener la hora actual en Excel usando una f\u00f3rmula, debe usar la funci\u00f3n AHORA de Excel junto con la funci\u00f3n TRUNC. Con estas dos funciones puedes obtener la hora actual en una celda. Pero debe comprender que AHORA es una funci\u00f3n vol\u00e1til que se actualiza cada vez que se actualiza su hoja. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79372\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-heure-actuelle-dans-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"tiempo-actual-en-excel\" width=\"498\" height=\"302\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> F\u00f3rmula para obtener la hora actual en Excel<\/h2>\n<p> Puede utilizar los siguientes pasos:<\/p>\n<ol type=\"1\">\n<li> Primero, en una celda, ingrese la funci\u00f3n AHORA (ahora no necesita especificar ning\u00fan argumento).<\/li>\n<li> Luego, ingrese el operador menos.<\/li>\n<li> Ahora ingrese a la funci\u00f3n TRUNC.<\/li>\n<li> Despu\u00e9s de eso, en TRUNC, ingrese a la funci\u00f3n AHORA.<\/li>\n<li> Al final, cierre la funci\u00f3n TRUNC y presione Enter para obtener el resultado. <\/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-79373\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formules-pour-obtenir-lheure-actuelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"f\u00f3rmula-para-obtener-la-hora-actual\" width=\"568\" height=\"278\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=NOW()-TRUNC(NOW())<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> \u00bfC\u00f3mo funciona esta f\u00f3rmula?<\/h2>\n<p> Excel almacena una fecha como un n\u00famero entero y la hora como un valor decimal. Ahora, cuando ingresa la funci\u00f3n AHORA en una celda, devuelve la fecha y hora actuales. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79374\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-formule-maintenant.png\" sizes=\"auto, \" srcset=\"\" alt=\"f\u00f3rmula ahora\" width=\"679\" height=\"190\"><\/figure>\n<\/div>\n<p> Pero, para entender esta f\u00f3rmula, es necesario dividirla en dos partes. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79375\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-formule-maintenant-et-tronc.png\" sizes=\"auto, \" srcset=\"\" alt=\"f\u00f3rmula ahora y trunc\" width=\"551\" height=\"158\"><\/figure>\n<\/div>\n<p> En la primera parte, tenemos la funci\u00f3n AHORA que devuelve la fecha y hora actuales (fecha en n\u00famero entero y hora en decimal). <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79376\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-premiere-partie-a-maintenant-la-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"la-primera-parte-ahora-tiene-la-f\u00f3rmula\" width=\"558\" height=\"218\"><\/figure>\n<\/div>\n<p> En la segunda parte tenemos la funci\u00f3n AHORA nuevamente pero envuelta en TRUNC. La funci\u00f3n TRUNC elimina la parte completa de los valores devueltos por AHORA. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79377\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-deuxieme-partie-a-une-formule-tronconique.png\" sizes=\"auto, \" srcset=\"\" alt=\"f\u00f3rmula-segunda-parte-de-un-tronco\" width=\"511\" height=\"272\"><\/figure>\n<\/div>\n<p> Del resultado de la primera parte tienes la fecha y la hora. Y del resultado de la segunda parte s\u00f3lo queda la fecha. Y es por eso que s\u00f3lo obtienes tiempo en el resultado cuando est\u00e1s a un segundo del primero. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79378\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-date-et-heure-moins-date-egale-a-lheure.png\" sizes=\"auto, \" srcset=\"\" alt=\"fecha y hora menos fecha es igual a hora\" width=\"482\" height=\"106\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Puntos importantes<\/h2>\n<ul>\n<li> AHORA es una funci\u00f3n vol\u00e1til y cambiar\u00e1 cuando actualice algo en su hoja de c\u00e1lculo. Tambi\u00e9n puede convertir la f\u00f3rmula en valor usando la funci\u00f3n especial copiar y pegar.<\/li>\n<li> AHORA le muestra la hora seg\u00fan la hora en la que se encuentra en su sistema. <\/li>\n<\/ul>\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\/heure-actuelle.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\/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\/\">Calcular la diferencia horaria entre dos horas en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/cambiar-formato-de-hora\/\">Cambiar formato de hora en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/tiempo-militar\/\">Hora militar (obtener y restar) en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/fecha-y-hora-separadas-2\/\">Separar fecha y hora en Excel<\/a><\/li>\n<\/ul>\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>Para obtener la hora actual en Excel usando una f\u00f3rmula, debe usar la funci\u00f3n AHORA de Excel junto con la funci\u00f3n TRUNC. Con estas dos funciones puedes obtener la hora actual en una celda. Pero debe comprender que AHORA es una funci\u00f3n vol\u00e1til que se actualiza cada vez que se actualiza su hoja. F\u00f3rmula para [&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-231","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 obtener la hora actual 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\/hora-actual-2\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo obtener la hora actual en excel?\" \/>\n<meta property=\"og:description\" content=\"Para obtener la hora actual en Excel usando una f\u00f3rmula, debe usar la funci\u00f3n AHORA de Excel junto con la funci\u00f3n TRUNC. Con estas dos funciones puedes obtener la hora actual en una celda. Pero debe comprender que AHORA es una funci\u00f3n vol\u00e1til que se actualiza cada vez que se actualiza su hoja. F\u00f3rmula para [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/hora-actual-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:26:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-heure-actuelle-dans-excel.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\/hora-actual-2\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/hora-actual-2\/\",\"name\":\"\u00bfc\u00f3mo obtener la hora actual en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/hora-actual-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/hora-actual-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-heure-actuelle-dans-excel.png\",\"datePublished\":\"2023-11-10T17:00:39+00:00\",\"dateModified\":\"2023-12-25T10:26:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/hora-actual-2\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/hora-actual-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/hora-actual-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-heure-actuelle-dans-excel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-heure-actuelle-dans-excel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/hora-actual-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo obtener la hora actual 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 obtener la hora actual 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\/hora-actual-2\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo obtener la hora actual en excel?","og_description":"Para obtener la hora actual en Excel usando una f\u00f3rmula, debe usar la funci\u00f3n AHORA de Excel junto con la funci\u00f3n TRUNC. Con estas dos funciones puedes obtener la hora actual en una celda. Pero debe comprender que AHORA es una funci\u00f3n vol\u00e1til que se actualiza cada vez que se actualiza su hoja. F\u00f3rmula para [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/hora-actual-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:26:26+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-heure-actuelle-dans-excel.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\/hora-actual-2\/","url":"https:\/\/exceladvisor.org\/es\/hora-actual-2\/","name":"\u00bfc\u00f3mo obtener la hora actual en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/hora-actual-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/hora-actual-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-heure-actuelle-dans-excel.png","datePublished":"2023-11-10T17:00:39+00:00","dateModified":"2023-12-25T10:26:26+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/hora-actual-2\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/hora-actual-2\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/hora-actual-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-heure-actuelle-dans-excel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-heure-actuelle-dans-excel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/hora-actual-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo obtener la hora actual 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\/231","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=231"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/231\/revisions"}],"predecessor-version":[{"id":1140,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/231\/revisions\/1140"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=231"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}