{"id":1604,"date":"2016-09-26T14:26:25","date_gmt":"2016-09-26T22:26:25","guid":{"rendered":"http:\/\/www.auval.com.mx\/notas\/?p=1604"},"modified":"2016-09-26T14:26:25","modified_gmt":"2016-09-26T22:26:25","slug":"atender-a-7-pacientes-por-hora","status":"publish","type":"post","link":"https:\/\/auval.com.mx\/blog\/en\/2016\/09\/26\/atender-a-7-pacientes-por-hora\/","title":{"rendered":"Atender a 7 pacientes por hora."},"content":{"rendered":"<p>Supongamos que queremos atender a 7 pacientes por hora. Empieza a las 7 am. Sale a comer de 12 am a 1 pm. Termina a las 7:00 pm.<\/p>\n<p>Tendremos una tabla as\u00ed.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1605\" src=\"http:\/\/www.auval.com.mx\/notas\/wp-content\/uploads\/Horario.png\" alt=\"horario\" width=\"473\" height=\"165\" \/><\/p>\n<p>En A2 capturamos la fecha de la primera cita.<\/p>\n<p>En B2 capturamos las 7:00 am.<\/p>\n<p>En C3 ponemos el nombre el primer paciente.<\/p>\n<p>En D2 escribimos esta f\u00f3rmula:<\/p>\n<p>=IF(A2+1\/24\/7&gt;=TIME(19,0,0),WORKDAY(A2,1),A2)<\/p>\n<p>=SI(A2+1\/24\/7&gt;=NSHORA(19,0,0),DIA.LAB(A2,1),A2)<\/p>\n<p>En E2 va esta f\u00f3rmula:<\/p>\n<p>=IF(D2&gt;A2,TIME(7,0,0),IF(HOUR(B2+1\/7\/24)=12,TIME(13,0,0),B2+1\/7\/24))<\/p>\n<p>=SI(D2&gt;A2,NSHORA(7,0,0),SI(HORA(B2+1\/7\/24)=12,NSHORA(13,0,0),B2+1\/7\/24))<\/p>\n<p>En A3 escribimos esto:<\/p>\n<p>=D2<\/p>\n<p>Y en B3, esto:<\/p>\n<p>=E2<\/p>\n<p>Listo.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Supongamos que queremos atender a 7 pacientes por hora. Empieza a las 7 am. Sale a comer de 12 am a 1 pm. Termina a las 7:00 pm. Tendremos una tabla as\u00ed. En A2 capturamos la fecha de la primera &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"https:\/\/auval.com.mx\/blog\/en\/2016\/09\/26\/atender-a-7-pacientes-por-hora\/\"> <span class=\"screen-reader-text\">Atender a 7 pacientes por hora.<\/span> Read More &raquo;<\/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-1604","post","type-post","status-publish","format-standard","hentry","category-office"],"_links":{"self":[{"href":"https:\/\/auval.com.mx\/blog\/en\/wp-json\/wp\/v2\/posts\/1604","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/auval.com.mx\/blog\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/auval.com.mx\/blog\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/en\/wp-json\/wp\/v2\/comments?post=1604"}],"version-history":[{"count":0,"href":"https:\/\/auval.com.mx\/blog\/en\/wp-json\/wp\/v2\/posts\/1604\/revisions"}],"wp:attachment":[{"href":"https:\/\/auval.com.mx\/blog\/en\/wp-json\/wp\/v2\/media?parent=1604"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/en\/wp-json\/wp\/v2\/categories?post=1604"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/en\/wp-json\/wp\/v2\/tags?post=1604"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}