{"id":105,"date":"2023-11-16T10:10:02","date_gmt":"2023-11-16T10:10:02","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/agregar-minutos-al-tiempo\/"},"modified":"2023-12-25T10:27:32","modified_gmt":"2023-12-25T10:27:32","slug":"agregar-minutos-al-tiempo","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/agregar-minutos-al-tiempo\/","title":{"rendered":"\u00bfc\u00f3mo sumar minutos al tiempo?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-318408305\"><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>Puede haber ocasiones en las que necesites agregar minutos espec\u00edficos a un tiempo que ya tienes en una celda en Excel.<\/p>\n<p> En Excel, el tiempo se almacena como una fracci\u00f3n de un valor num\u00e9rico. Entonces, un d\u00eda completo de 24 horas es igual a 1. Y en este tutorial, aprenderemos c\u00f3mo hacer esto usando una f\u00f3rmula.<\/p>\n<h2 class=\"wp-block-heading\"> Agregar minutos al tiempo<\/h2>\n<p> Ahora pi\u00e9nselo de esta manera: hay (24*60) un total de 1440 minutos en un d\u00eda. Entonces, si quisieras agregar un minuto a un valor de tiempo, ser\u00eda (1\/1440). En el siguiente ejemplo, tiene la hora 00:01 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-64234\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-des-minutes-au-temps.png\" sizes=\"auto, \" srcset=\"\" alt=\"agregar minutos al tiempo\" width=\"393\" height=\"225\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1+(10\/1440)<\/code><\/pre>\n<p> En la celda B1, sumamos (1\/1440) minutos al valor de la celda A1 y obtuvimos 00:02. Ahora digamos que desea agregar m\u00e1s de un minuto (diez minutos), en este caso debe agregar (10\/1440) en el valor de tiempo. Vea el siguiente ejemplo para comprenderlo. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64235\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-ajouter-plus-dune-minute.png\" sizes=\"auto, \" srcset=\"\" alt=\"agregar m\u00e1s de un minuto\" width=\"392\" height=\"245\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Usando la funci\u00f3n TIEMPO para agregar tiempo<\/h2>\n<p> Tambi\u00e9n puede utilizar la funci\u00f3n TIEMPO para agregar minutos a una hora. Utilizar este m\u00e9todo tiene una ventaja sobre el m\u00e9todo anterior: no es necesario calcular minutos.<\/p>\n<p> La funci\u00f3n de tiempo le permite agregar minutos como un n\u00famero en el argumento, por lo que si desea agregar 15 o 30 minutos, simplemente puede ingresarlo en la funci\u00f3n.<\/p>\n<p> Hay tres argumentos en la funci\u00f3n TIEMPO y debes especificar los valores de los minutos en el segundo argumento. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64236\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-3-temps-pour-ajouter-du-temps.png\" sizes=\"auto, \" srcset=\"\" alt=\"funci\u00f3n-tiempo-para-agregar-tiempo\" width=\"319\" height=\"151\"><\/figure>\n<\/div>\n<p> Pongamos un ejemplo para entenderlo. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64237\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Exemple-de-fonction-4-temps.png\" sizes=\"auto, \" srcset=\"\" alt=\"ejemplo de funci\u00f3n de tiempo\" width=\"439\" height=\"242\"><\/figure>\n<\/div>\n<p> Tienes la hora como 00:01 en la celda A1, y usando la funci\u00f3n de tiempo especificamos 15 minutos para agregar, y en el resultado tenemos 00:16. <\/p>\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\/11\/ajouter-des-minutes-au-temps-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-11\">\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\/calcular-la-diferencia-horaria\/\">Diferencia entre dos tiempos 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<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Puede haber ocasiones en las que necesites agregar minutos espec\u00edficos a un tiempo que ya tienes en una celda en Excel. En Excel, el tiempo se almacena como una fracci\u00f3n de un valor num\u00e9rico. Entonces, un d\u00eda completo de 24 horas es igual a 1. Y en este tutorial, aprenderemos c\u00f3mo hacer esto usando una [&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-105","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 sumar minutos al tiempo?<\/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\/agregar-minutos-al-tiempo\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo sumar minutos al tiempo?\" \/>\n<meta property=\"og:description\" content=\"Puede haber ocasiones en las que necesites agregar minutos espec\u00edficos a un tiempo que ya tienes en una celda en Excel. En Excel, el tiempo se almacena como una fracci\u00f3n de un valor num\u00e9rico. Entonces, un d\u00eda completo de 24 horas es igual a 1. Y en este tutorial, aprenderemos c\u00f3mo hacer esto usando una [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/agregar-minutos-al-tiempo\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:27:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-des-minutes-au-temps.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\/agregar-minutos-al-tiempo\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/agregar-minutos-al-tiempo\/\",\"name\":\"\u00bfc\u00f3mo sumar minutos al tiempo?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/agregar-minutos-al-tiempo\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/agregar-minutos-al-tiempo\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-des-minutes-au-temps.png\",\"datePublished\":\"2023-11-16T10:10:02+00:00\",\"dateModified\":\"2023-12-25T10:27:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/agregar-minutos-al-tiempo\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/agregar-minutos-al-tiempo\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/agregar-minutos-al-tiempo\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-des-minutes-au-temps.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-des-minutes-au-temps.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/agregar-minutos-al-tiempo\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo sumar minutos al tiempo?\"}]},{\"@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 sumar minutos al tiempo?","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\/agregar-minutos-al-tiempo\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo sumar minutos al tiempo?","og_description":"Puede haber ocasiones en las que necesites agregar minutos espec\u00edficos a un tiempo que ya tienes en una celda en Excel. En Excel, el tiempo se almacena como una fracci\u00f3n de un valor num\u00e9rico. Entonces, un d\u00eda completo de 24 horas es igual a 1. Y en este tutorial, aprenderemos c\u00f3mo hacer esto usando una [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/agregar-minutos-al-tiempo\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:27:32+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-des-minutes-au-temps.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\/agregar-minutos-al-tiempo\/","url":"https:\/\/exceladvisor.org\/es\/agregar-minutos-al-tiempo\/","name":"\u00bfc\u00f3mo sumar minutos al tiempo?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/agregar-minutos-al-tiempo\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/agregar-minutos-al-tiempo\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-des-minutes-au-temps.png","datePublished":"2023-11-16T10:10:02+00:00","dateModified":"2023-12-25T10:27:32+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/agregar-minutos-al-tiempo\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/agregar-minutos-al-tiempo\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/agregar-minutos-al-tiempo\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-des-minutes-au-temps.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-des-minutes-au-temps.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/agregar-minutos-al-tiempo\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo sumar minutos al tiempo?"}]},{"@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\/105","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=105"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/105\/revisions"}],"predecessor-version":[{"id":1206,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/105\/revisions\/1206"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}