Buenas tardes tengo esta tabla:
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[TD="align: center"][/TD]
[TD="align: center"]J[/TD]
[TD="align: center"][/TD]
[TD="align: center"]K[/TD]
[/TR]
[TR]
[TD]Dia[/TD]
[TD]H Entrada[/TD]
[TD]H Salida[/TD]
[TD]Formula Para HE 25%[/TD]
[TD]HE 25%[/TD]
[TD]Formula Para HE 50%[/TD]
[TD]HE 50%[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]17[/TD]
[TD="align: center"]=SI(I3>=19.1,"3",(I3-H3-9))[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]=(I3-H3-9-J3)[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]19[/TD]
[TD="align: center"]=SI(I3>=19.1,"3",(I3-H3-9))[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]=(I3-H3-9-J3)[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]21[/TD]
[TD="align: center"]=SI(I3>=19.1,"3",(I3-H3-9))[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]=(I3-H3-9-J3)[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]16[/TD]
[TD="align: center"]=SI(I3>=19.1,"3",(I3-H3-9))[/TD]
[TD="align: center"]-1[/TD]
[TD="align: center"]=(I3-H3-9-J3)[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]18.5[/TD]
[TD="align: center"]=SI(I3>=19.1,"3",(I3-H3-9))[/TD]
[TD="align: center"]1.5[/TD]
[TD="align: center"]=(I3-H3-9-J3)[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]Total HE 25%[/TD]
[TD="align: center"]5.5[/TD]
[TD="align: center"]Total HE 50%[/TD]
[TD="align: center"]2[/TD]
[/TR]
</tbody>[/TABLE]
Me trabajaba bien porque no trabajaba con horas ni minutos pero ahora quieren que los calculos se hagan distintos y no se como hacerlo la tabla seria algo asi:
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[TD="align: center"][/TD]
[TD="align: center"]J[/TD]
[TD="align: center"][/TD]
[TD="align: center"]K[/TD]
[/TR]
[TR]
[TD]Dia[/TD]
[TD]H Entrada[/TD]
[TD]H Salida[/TD]
[TD]Formula Para HE 25%[/TD]
[TD]HE 25%[/TD]
[TD]Formula Para HE 50%[/TD]
[TD]HE 50%[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]17:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]19:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]21:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]16:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]18:30[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1:30[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]8:15[/TD]
[TD="align: center"]17:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-0:15[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]8:40[/TD]
[TD="align: center"]17:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-0:40[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]22:20[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]3:20[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]Total HE 25%[/TD]
[TD="align: center"]7:30[/TD]
[TD="align: center"]Total HE 50%[/TD]
[TD="align: center"]5:20[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]Total H Deducir[/TD]
[TD="align: center"]1:55[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]
Agradecere mucho si alguien me puede colaborar para resolver esto.
Gracias de antemano
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Formula Para HE 25%[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[TD="align: center"][/TD]
[TD="align: center"]J[/TD]
[TD="align: center"][/TD]
[TD="align: center"]K[/TD]
[/TR]
[TR]
[TD]Dia[/TD]
[TD]H Entrada[/TD]
[TD]H Salida[/TD]
[TD]Formula Para HE 25%[/TD]
[TD]HE 25%[/TD]
[TD]Formula Para HE 50%[/TD]
[TD]HE 50%[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]17[/TD]
[TD="align: center"]=SI(I3>=19.1,"3",(I3-H3-9))[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]=(I3-H3-9-J3)[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]19[/TD]
[TD="align: center"]=SI(I3>=19.1,"3",(I3-H3-9))[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]=(I3-H3-9-J3)[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]21[/TD]
[TD="align: center"]=SI(I3>=19.1,"3",(I3-H3-9))[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]=(I3-H3-9-J3)[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]16[/TD]
[TD="align: center"]=SI(I3>=19.1,"3",(I3-H3-9))[/TD]
[TD="align: center"]-1[/TD]
[TD="align: center"]=(I3-H3-9-J3)[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]18.5[/TD]
[TD="align: center"]=SI(I3>=19.1,"3",(I3-H3-9))[/TD]
[TD="align: center"]1.5[/TD]
[TD="align: center"]=(I3-H3-9-J3)[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]Total HE 25%[/TD]
[TD="align: center"]5.5[/TD]
[TD="align: center"]Total HE 50%[/TD]
[TD="align: center"]2[/TD]
[/TR]
</tbody>[/TABLE]
Me trabajaba bien porque no trabajaba con horas ni minutos pero ahora quieren que los calculos se hagan distintos y no se como hacerlo la tabla seria algo asi:
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[TD="align: center"][/TD]
[TD="align: center"]J[/TD]
[TD="align: center"][/TD]
[TD="align: center"]K[/TD]
[/TR]
[TR]
[TD]Dia[/TD]
[TD]H Entrada[/TD]
[TD]H Salida[/TD]
[TD]Formula Para HE 25%[/TD]
[TD]HE 25%[/TD]
[TD]Formula Para HE 50%[/TD]
[TD]HE 50%[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]17:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]19:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]21:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]16:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]18:30[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1:30[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]8:15[/TD]
[TD="align: center"]17:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-0:15[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]8:40[/TD]
[TD="align: center"]17:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-0:40[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]22:20[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]3:20[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]Total HE 25%[/TD]
[TD="align: center"]7:30[/TD]
[TD="align: center"]Total HE 50%[/TD]
[TD="align: center"]5:20[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]Total H Deducir[/TD]
[TD="align: center"]1:55[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]
Agradecere mucho si alguien me puede colaborar para resolver esto.
Gracias de antemano
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Formula Para HE 25%[/TD]
[/TR]
</tbody>[/TABLE]
Last edited by a moderator: