<div dir="ltr"><div class="gmail_default" style="font-family:'courier new',monospace;color:rgb(0,0,0)">Podés sacar el máximo y mínimo para un usuario y saber el tiempo total. Luego a eso le descontás el tiempo NO trabajado, que serían las tareas de más de 5 minutos o lo que sea.</div>
<div class="gmail_default" style="font-family:'courier new',monospace;color:rgb(0,0,0)">La verdad que así como está no se me ocurre como poder sacar un valor aproximado sin, como bien dijo Carlos, darle una duración promedio a las tareas.</div>
</div><div class="gmail_extra"><br clear="all"><div><div><br></div>.:-:ChiCkENURiNE:-:.<div><span>+ </span><span>El <a href="http://groups.google.com/group/spam-a-lot/" target="_blank">SPAM</a> tiene su lugar.</span></div>
</div>
<br><br><div class="gmail_quote">2013/3/25 Gustavo Azambuja <span dir="ltr"><<a href="mailto:hola@gazambuja.com" target="_blank">hola@gazambuja.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Si, entiendo. El tema es que no puedo cambiar la estructura que está... pero me diste algo para pensar con lo de t0+5min... creo que por ahí lo soluciono.<div>Gracias!</div></div><div class="HOEnZb"><div class="h5">
<div class="gmail_extra">
<br><br><div class="gmail_quote">2013/3/25 Carlos M. Martinez <span dir="ltr"><<a href="mailto:carlosmarcelomartinez@gmail.com" target="_blank">carlosmarcelomartinez@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
El tema es que medir duración de algo es como que lógicamente
incompatible con la hipótesis de que las acciones son instantáneas
(es decir de duración 0, por lo cual la sumatoria siempre seria 0)<br>
<br>
Para calcular la cantidad de minutos ocupados en eso, se me ocurren
algunas cosas:<br>
<br>
- asumir una duracion por tarea, es decir, si aprete enter en t0, la
tarea duro hasta t0+5min<br>
- agregar una columna de 'fin' de la accion, tratando de medir
cuando ese fin ocurre, creo que esto es lo mas razonable, ya que en
realidad nada es instantáneo<br>
- asumir que la duracion de la tarea es entre enters sucesivos del
mismo usuario, asumiendo que trabajan siempre, lo cual te deja
abierta la duracion del ultimo 'enter' del dia<br>
<br>
- Y finalmente, pensar si en el caso de que realmente las acciones
sean logicamente instantaneas, si la metrica 'minutos trabajados'
tiene sentido, si no hace falta una metrica que sea 'cantidad de
enters por unidad de tiempo', o algo parecido.<br>
<br>
Creo que como dice Chicken, falta algo en el modelado de tu
realidad.<br>
<br>
s2<span><font color="#888888"><br>
<br>
~C.</font></span><div><div><br>
<br>
<div>On 3/25/13 11:45 AM, Gustavo Azambuja
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Carlos, gracias por responder... es que no son
"tareas" mas bien son "acciones"...
<div>Imaginen que tienen una tabla donde los
funcionarios que tienen cada ENTER que apreto un
usuario/funcionario, y en la columna date, lo que aparece es
la hora en que apreto ENTER...</div>
<div><br>
</div>
<div><br>
</div>
<div>
<pre style="white-space:pre-wrap;max-height:600px;width:auto;background-color:rgb(238,238,238);margin-bottom:10px;padding:5px;vertical-align:baseline;line-height:18px;font-size:14px;overflow:auto;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif;margin-top:0px;border:0px">
<code style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif"><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">id</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(0,0,139)">user</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> action</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> date
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:base line;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">01</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:base line;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">03</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">3</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:base line;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">12</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">4</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user3</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:base line;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">20</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">5</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:base line;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"><font color="#800000">24
...
</font><span style="background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline"><font color="#800000">10</font></span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">,</span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline"> user3</span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">,</span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline"> a1</span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">,</span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline"> </span><span style="color:rgb(128,0,0);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline"> </span><span style="color:rgb(128,0,0);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">10</span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">:</span><span style="color:rgb(128,0,0);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">02</span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">:</span><span style="color:rgb(128,0,0);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">35
...
<span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline"><font color="#800000">16</font></span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline">,</span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline"> user3</span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline">,</span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline"> a1</span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline">,</span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline"> </span><span><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline"> </span><span style="background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">10</span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline">:</span><span style="background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">04</span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline">:</span><span style="background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">01</span>
</span><font color="#800000">
</font></span></code></pre>
</div>
<div><br>
</div>
<div>El usuario user1: apreto solo una vez ENTER: 10h
00m 01s; el user2, :03s, :12s, y :24s</div>
<div>Ahora, por ejemplo el user3, esta "apretando
ENTER" cada algunos cuantos segundos, y luego del id=16 no
aparece mas... podría decir entonces que el user3 trabajó
desde 10:00 hasta las 10:04 (4 minutos trabajados)</div>
<div><br>
</div>
<div>el tema es como consigo llegar a esa conclusion
usando PHP y MySQL...</div>
<div><br>
</div>
<div>Como dije antes, asumo que el usuario ya no está
trabajando si pasan mas de 5 minutos sin "acciones"
realizadas.</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">2013/3/25 Carlos M. Martinez <span dir="ltr"><<a href="mailto:carlosmarcelomartinez@gmail.com" target="_blank">carlosmarcelomartinez@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Pero como definis la
'duracion' de cada tarea ? el intervalo entre dos entradas
? <br>
<div>
<div> <br>
<div>On 3/25/13 10:50 AM, Gustavo Azambuja wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">No, la tarea es "instantanea"...
digamos, para entender, que cada registro es una
pulsación de ENTER en el teclado del usuario...
sabiendo eso, y que jamas pasan 5 minutos sin dar
ENTER a menos que no estén trabajando... como
consigo saber los "minutos trabajados por
operador" (o la suma de todos los operadores)?
<div> <br>
</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">2013/3/25 Chicken Urine <span dir="ltr"><<a href="mailto:chickenurine@gmail.com" target="_blank">chickenurine@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div class="gmail_default">Ok, entonces el
date ese es la hora de inicio de la tarea,
por lo que supongo que la duración de una
tarea es el tiempo entre 2 registros?</div>
</div>
<div class="gmail_extra">
<div><br clear="all">
<div>
<div><br>
</div>
.:-:ChiCkENURiNE:-:.
<div><span>+ </span><span>El <a href="http://groups.google.com/group/spam-a-lot/" target="_blank">SPAM</a> tiene su
lugar.</span></div>
</div>
<br>
<br>
</div>
<div>
<div>
<div class="gmail_quote">2013/3/25
Gustavo Azambuja <span dir="ltr"><<a href="mailto:hola@gazambuja.com" target="_blank">hola@gazambuja.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<p dir="ltr">La columna date tiene
el datetime del evento (q ejecutó
una acción) </p>
<p dir="ltr">En definitiva tengo una
lista de eventos de diferentes
usuarios y necesito calcular los
"minutos trabajados totales) </p>
<p dir="ltr">Para el cálculo asumo
que si el usuario no ejecuta
eventos en 5 minutos no está
trabajando. </p>
<p dir="ltr">Uso MySQL, y podría
completar el cálculo con php. </p>
<div class="gmail_quote">El mar 25,
2013 8:20 a.m., "Chicken Urine"
<<a href="mailto:chickenurine@gmail.com" target="_blank">chickenurine@gmail.com</a>>
escribió:
<div>
<div><br type="attribution">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div class="gmail_default">Gustavo,
no me queda muy claro el
ejemplo. La columna date
guarda un resultado de
HH:MM:ss que llevó un
tarea particular? O es
la hora de comienzo/fin?</div>
<div class="gmail_default">Que
rdbms estás utilizando?
Ya que hay funciones
específicas en cada
motor para el manejo de
tipo de datos date.</div>
</div>
<div class="gmail_extra"> <br clear="all">
<div>
<div><br>
</div>
.:-:ChiCkENURiNE:-:.
<div><span>+ </span><span>El
<a href="http://groups.google.com/group/spam-a-lot/" target="_blank">SPAM</a>
tiene su lugar.</span></div>
</div>
<br>
<br>
<div class="gmail_quote">2013/3/24
Gustavo Azambuja <span dir="ltr"><<a href="mailto:hola@gazambuja.com" target="_blank">hola@gazambuja.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div>Alguien me
puede ayudar con
esta query?</div>
<div><br>
</div>
<div>básicamente,
necesito conseguir
en base a una
tabla que tiene
acciones
realizadas por mis
usuarios
(funcionarios)
durante cada
minuto. Ahora,
necesito en base a
esa tabla saber
los "minutos
trabajados"</div>
<div><br>
</div>
<a href="http://stackoverflow.com/questions/15606675/minutes-work-by-users-how-to-make-this-query" target="_blank">http://stackoverflow.com/questions/15606675/minutes-work-by-users-how-to-make-this-query</a><br clear="all">
<div><br>
</div>
<div>
<pre style="max-height:600px;width:auto;background-color:rgb(238,238,238);margin-bottom:10px;padding:5px;vertical-align:baseline;line-height:18px;font-size:14px;overflow:auto;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif;margin-top:0px;border:0px">
<code style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif"><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">id</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(0,0,139)">user</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> action</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> date
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">01</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">03</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">3</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">12</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">4</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user3</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">20</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">5</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">24</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">....</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">...</span></code></pre>
<p> Por ejemplo:</p>
<ol>
<li style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;word-wrap:break-word">Si
tengo solo un
funcionario
trabajando las
24h, tendré:
24h*60m = 1440
minutos
trabajados en
el día.</li>
<li style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;word-wrap:break-word">Si
tengo 2
funcionarios
durante todo
el día (24h)
tendré: 2880
minutos
trabajados
hoy...</li>
<li style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;word-wrap:break-word">Si
tengo los
mismos dos
funcionarios,
pero
trabajando 12h
cada uno,
vuelvo a tener
los 1440
m/día.</li>
</ol>
<div><font color="#000000" face="Arial,
Liberation
Sans, DejaVu
Sans,
sans-serif"><span style="font-size:14px;line-height:18px">Alguna idea de como podría armar
una query que
me de ésto? o
como mucho con
algo de PHP
ademas de la
query.</span></font></div>
</div>
<div><font color="#000000" face="Arial,
Liberation Sans,
DejaVu Sans,
sans-serif"><span style="font-size:14px;line-height:18px"><br>
</span></font></div>
<div><font color="#000000" face="Arial,
Liberation Sans,
DejaVu Sans,
sans-serif"><span style="font-size:14px;line-height:18px">Gracias!</span></font></div>
<span><font color="#888888">
<div><br>
</div>
<div><br>
</div>
-- <br>
<font face="'trebuchet
ms',
sans-serif">Gustavo
Azambuja<br>
</font><a href="http://gazambuja.com" target="_blank"><font face="'trebuchet ms',
sans-serif">http://gazambuja.com</font></a>
<div> <br>
<font face="'courier
new',
monospace"><span style="font-size:x-small">Uruguay:</span></font><font face="'courier
new',
monospace"><span style="white-space:pre-wrap"><span style="font-size:x-small"> </span></span></font><font face="'courier
new',
monospace"><span style="font-size:x-small"><b><a href="tel:091%20300%20333" value="+59891300333" target="_blank">091 300 333</a></b> (Montevideo -
Mobile)</span></font><font face="'courier
new',
monospace"><span style="font-size:x-small"><br>
</span></font></div>
</font></span></div>
<br>
_______________________________________________<br>
Uylug-programming
mailing list<br>
<a href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy" target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a><br>
<br>
</blockquote>
</div>
<br>
</div>
<br>
_______________________________________________<br>
Uylug-programming mailing
list<br>
<a href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy" target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a><br>
<br>
</blockquote>
</div>
</div>
</div>
<br>
_______________________________________________<br>
Uylug-programming mailing list<br>
<a href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy" target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
<br>
_______________________________________________<br>
Uylug-programming mailing list<br>
<a href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy" target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a><br>
<br>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<font face="'trebuchet ms', sans-serif">Gustavo
Azambuja<br>
</font><a href="http://gazambuja.com" target="_blank"><font face="'trebuchet ms', sans-serif">http://gazambuja.com</font></a>
<div> <br>
<font face="'courier new', monospace"><span style="font-size:x-small">Uruguay:</span></font><font face="'courier new', monospace"><span style="white-space:pre-wrap"><span style="font-size:x-small"> </span></span></font><font face="'courier new', monospace"><span style="font-size:x-small"><b><a href="tel:091%20300%20333" value="+59891300333" target="_blank">091 300 333</a></b>
(Montevideo - Mobile)</span></font><font face="'courier new', monospace"><span style="font-size:x-small"><br>
</span></font></div>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
Uylug-programming mailing list
<a href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a>
<a href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy" target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a>
</pre>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<font face="'trebuchet ms', sans-serif">Gustavo Azambuja<br>
</font><a href="http://gazambuja.com" target="_blank"><font face="'trebuchet ms', sans-serif">http://gazambuja.com</font></a>
<div>
<br>
<font face="'courier new', monospace"><span style="font-size:x-small">Uruguay:</span></font><font face="'courier new', monospace"><span style="white-space:pre-wrap"><span style="font-size:x-small">
</span></span></font><font face="'courier new', monospace"><span style="font-size:x-small"><b><a href="tel:091%20300%20333" value="+59891300333" target="_blank">091 300 333</a></b> (Montevideo -
Mobile)</span></font><font face="'courier new', monospace"><span style="font-size:x-small"><br>
</span></font></div>
</div>
</blockquote>
<br>
</div></div></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><font face="'trebuchet ms', sans-serif">Gustavo Azambuja<br></font><a href="http://gazambuja.com" target="_blank"><font face="'trebuchet ms', sans-serif">http://gazambuja.com</font></a><div>
<a href="http://gazambuja.com" target="_blank"></a><br><font face="'courier new', monospace"><span style="font-size:x-small">Uruguay:</span></font><font face="'courier new', monospace"><span style="white-space:pre-wrap"><span style="font-size:x-small"> </span></span></font><font face="'courier new', monospace"><span style="font-size:x-small"><b><a href="tel:091%20300%20333" value="+59891300333" target="_blank">091 300 333</a></b> (Montevideo - Mobile)</span></font><font face="'courier new', monospace"><span style="font-size:x-small"><br>
</span></font></div>
</div>
</div></div><br>_______________________________________________<br>
Uylug-programming mailing list<br>
<a href="mailto:Uylug-programming@listas.uylug.org.uy">Uylug-programming@listas.uylug.org.uy</a><br>
<a href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy" target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a><br>
<br></blockquote></div><br></div>