{"id":534,"date":"2011-10-04T17:05:36","date_gmt":"2011-10-05T01:05:36","guid":{"rendered":"http:\/\/www.auval.com.mx\/notas\/?p=534"},"modified":"2011-10-04T17:05:36","modified_gmt":"2011-10-05T01:05:36","slug":"como-sumarle-30-minutos-a-una-hora-especifica","status":"publish","type":"post","link":"https:\/\/auval.com.mx\/blog\/2011\/10\/04\/como-sumarle-30-minutos-a-una-hora-especifica\/","title":{"rendered":"C\u00f3mo sumarle 30 minutos a una hora espec\u00edfica."},"content":{"rendered":"<p><span style=\"color: #888888;\">Hoy recib\u00ed la pregunta de c\u00f3mo hacer que una f\u00f3rmula le sumara media hora a una celda, y que se pudiera copiar hacer abajo.<\/span><\/p>\n<p><span style=\"color: #888888;\"><span style=\"color: #888888;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft\" title=\"Sumar_Minutos\" src=\"http:\/\/www.auval.com.mx\/notas\/images\/sumar_minutos.png\" alt=\"C\u00f3mo sumar minutos\" width=\"122\" height=\"161\" \/><\/span>Suponiendo que tenemos en la celda A1 la hora 8:00, en la celda A2 podemos escribir =A1 + 30 \/ 1440. Esto le sumar\u00e1 30 minutos a la hora de arriba, y al copiar hacia abajo, tendremos las diferentes horas.<\/span><\/p>\n<p><span style=\"color: #888888;\">Esta f\u00f3rmula funciona porque el 1, en Excel, representa un d\u00eda completo. Un d\u00eda tiene 24 horas, y como cada hora tiene 60 minutos, un d\u00eda tiene 1440 minutos (24 x 60).<\/span><\/p>\n<p><span style=\"color: #888888;\">Espero que este tip les sirva, as\u00ed como sus comentarios y preguntas a <a href=\"mailto:cu****@*******om.mx\" data-original-string=\"ll+jvKh2VbbysDRUFgTZjg==63eTp+Pwo2DbB5DZNjI5vYdscGuyY+670\/Ygg8JDmGWNkk=\" title=\"Este contacto ha sido codificado por Anti-Spam by CleanTalk. Haz clic para decodificar. Para finalizar la decodificaci\u00f3n, aseg\u00farate de que JavaScript est\u00e1 activado en tu navegador.\">esta direcci\u00f3n<\/a>.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>C\u00f3mo sumar minutos a una hora en Excel.<\/p>\n<div class=\"read-more\"><a href=\"https:\/\/auval.com.mx\/blog\/2011\/10\/04\/como-sumarle-30-minutos-a-una-hora-especifica\/\">Leer m\u00e1s \u203a<\/a><\/div>\n<p><!-- end of .read-more --><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,3],"tags":[54,104,105,106],"class_list":["post-534","post","type-post","status-publish","format-standard","hentry","category-excel","category-office","tag-excel","tag-horas","tag-minutos","tag-sumar"],"_links":{"self":[{"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/posts\/534","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/comments?post=534"}],"version-history":[{"count":0,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/posts\/534\/revisions"}],"wp:attachment":[{"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/media?parent=534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/categories?post=534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/tags?post=534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}