<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body 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<br>
<br>
~C.<br>
<br>
<div class="moz-cite-prefix">On 3/25/13 11:45 AM, Gustavo Azambuja
wrote:<br>
</div>
<blockquote
cite="mid:CABGE7dteqdW6jbfHaQ+C4i7jZYv2UAHZqHJY3mGyu1FwZdnSow@mail.gmail.com"
type="cite">
<div dir="ltr">Carlos, gracias por responder... es que no son
"tareas" mas bien son "acciones"...
<div style="">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 style=""><br>
</div>
<div style=""><br>
</div>
<div style="">
<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:tr
ansparent
">,</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)">2013-03-20</span><span style="margin:0px;padding:0px;border:0px;vertical-a
lign: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)">2013-03-20</span><span style="margin:0px;padding:0px;border:0px;vertical-a
lign: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)">2013-03-20</span><span style="margin:0px;padding:0px;border:0px;vertical-a
lign: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)">2013-03-20</span><span style="margin:0px;padding:0px;border:0px;vertical-a
lign: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)">2013-03-20</span><span style="margin:0px;padding:0px;border:0px;vertical-a
lign: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;ma
rgin:0px;
padding:0px;border:0px;vertical-align:baseline">2013-03-20</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 style="background-color:transparent;margin:0
px;paddin
g:0px;border:0px;vertical-align:baseline">2013-03-20</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 style=""><br>
</div>
<div style="">El usuario user1: apreto solo una vez ENTER: 10h
00m 01s; el user2, :03s, :12s, y :24s</div>
<div style="">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 style=""><br>
</div>
<div style="">el tema es como consigo llegar a esa conclusion
usando PHP y MySQL...</div>
<div style=""><br>
</div>
<div style="">Como dije antes, asumo que el usuario ya no está
trabajando si pasan mas de 5 minutos sin "acciones"
realizadas.</div>
<div style=""><br>
</div>
<div style=""><br>
</div>
<div style=""><br>
</div>
<div style=""><br>
</div>
<div style=""><br>
</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">2013/3/25 Carlos M. Martinez <span
dir="ltr"><<a moz-do-not-send="true"
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 class="h5"> <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 moz-do-not-send="true"
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
moz-do-not-send="true"
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
moz-do-not-send="true"
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 moz-do-not-send="true"
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
moz-do-not-send="true"
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
moz-do-not-send="true"
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
moz-do-not-send="true"
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:tr
ansparent
">,</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 moz-do-not-send="true" href="tel:2013-03-20" value="+59820130320" targe
t="_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 moz-do-not-send="true" href="tel:2013-03-20" value="+59820130320" targe
t="_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 moz-do-not-send="true" href="tel:2013-03-20" value="+59820130320" targe
t="_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 moz-do-not-send="true" href="tel:2013-03-20" value="+59820130320" targe
t="_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 moz-do-not-send="true" href="tel:2013-03-20" value="+59820130320" targe
t="_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
moz-do-not-send="true"
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 moz-do-not-send="true"
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
moz-do-not-send="true"
href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a
moz-do-not-send="true"
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 moz-do-not-send="true"
href="mailto:Uylug-programming@listas.uylug.org.uy"
target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a moz-do-not-send="true"
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 moz-do-not-send="true"
href="mailto:Uylug-programming@listas.uylug.org.uy"
target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a moz-do-not-send="true"
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 moz-do-not-send="true"
href="mailto:Uylug-programming@listas.uylug.org.uy"
target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a moz-do-not-send="true"
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 moz-do-not-send="true"
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>091 300 333</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 moz-do-not-send="true" href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a>
<a moz-do-not-send="true" 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 moz-do-not-send="true" 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"><span style="font-size:x-small">
</span></span></font><font face="'courier new', monospace"><span
style="font-size:x-small"><b>091 300 333</b> (Montevideo -
Mobile)</span></font><font face="'courier new', monospace"><span
style="font-size:x-small"><br>
</span></font></div>
</div>
</blockquote>
<br>
</body>
</html>