{"id":1632,"date":"2017-02-23T14:18:14","date_gmt":"2017-02-23T22:18:14","guid":{"rendered":"http:\/\/www.auval.com.mx\/notas\/?p=1632"},"modified":"2017-02-23T14:18:14","modified_gmt":"2017-02-23T22:18:14","slug":"cuenta-regresiva-timer-en-excel","status":"publish","type":"post","link":"https:\/\/auval.com.mx\/blog\/2017\/02\/23\/cuenta-regresiva-timer-en-excel\/","title":{"rendered":"Cuenta regresiva (timer) en Excel"},"content":{"rendered":"\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"745\" height=\"251\" src=\"http:\/\/www.auval.com.mx\/notas\/wp-content\/uploads\/muestra.png\" alt=\"\" class=\"wp-image-1633\"\/><\/figure><\/div>\n\n\n\n<pre class=\"wp-block-preformatted\">Sub conteo()\n    inicio = Now\n    restante = Range(\"b2\")\n    Do\n        DoEvents\n        Range(\"b2\") = inicio + restante - Now\n    Loop\nEnd Sub\n\nSub detener()\n    End\nEnd Sub\n<\/pre>\n\n\n\n<p>El archivo est\u00e1 <a href=\"http:\/\/www.auval.com.mx\/archivos\/Timer.xlsm\">en esta direcci\u00f3n<\/a>.<\/p>\n\n\n\n<p>Hice unas modificaciones y <a href=\"http:\/\/www.auval.com.mx\/notas\/wp-content\/uploads\/Timer-2.xlsm\">aqu\u00ed <\/a>pueden encontrar un archivo mejorado, con timer y cron\u00f3metro.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sub conteo() inicio = Now restante = Range(\u00abb2\u00bb) Do DoEvents Range(\u00abb2\u00bb) = inicio + restante &#8211; Now Loop End Sub Sub detener() End End Sub El archivo est\u00e1 en esta direcci\u00f3n. Hice unas modificaciones y aqu\u00ed pueden encontrar un archivo &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"https:\/\/auval.com.mx\/blog\/2017\/02\/23\/cuenta-regresiva-timer-en-excel\/\"> <span class=\"screen-reader-text\">Cuenta regresiva (timer) en Excel<\/span> Leer m\u00e1s \u00bb<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1632","post","type-post","status-publish","format-standard","hentry","category-office"],"_links":{"self":[{"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/posts\/1632","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=1632"}],"version-history":[{"count":0,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/posts\/1632\/revisions"}],"wp:attachment":[{"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/media?parent=1632"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/categories?post=1632"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/tags?post=1632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}