Thanks Thanks:  0
Likes Likes:  0
Results 1 to 1 of 1

Thread: Formulas Para Tabla de Horas

  1. #1
    New Member
    Join Date
    Oct 2017
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Formulas Para Tabla de Horas

    Buenas tardes tengo esta tabla:


    H I J K
    Dia H Entrada H Salida Formula Para HE 25% HE 25% Formula Para HE 50% HE 50%
    1 8 17 =SI(I3>=19.1,"3",(I3-H3-9)) 0 =(I3-H3-9-J3) 0
    2 8 19 =SI(I3>=19.1,"3",(I3-H3-9)) 2 =(I3-H3-9-J3) 0
    3 8 21 =SI(I3>=19.1,"3",(I3-H3-9)) 2 =(I3-H3-9-J3) 2
    4 8 16 =SI(I3>=19.1,"3",(I3-H3-9)) -1 =(I3-H3-9-J3) 0
    5 8 18.5 =SI(I3>=19.1,"3",(I3-H3-9)) 1.5 =(I3-H3-9-J3) 0
    Total HE 25% 5.5 Total HE 50% 2


    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:

    H I J K
    Dia H Entrada H Salida Formula Para HE 25% HE 25% Formula Para HE 50% HE 50%
    1 8:00 17:00 0 0
    2 8:00 19:00 2 0
    3 8:00 21:00 2 2
    4 8:00 16:00 -1 0
    5 8:00 18:30 1:30 0
    6 8:15 17:00 -0:15 0
    7 8:40 17:00 -0:40 0
    8 8:00 22:20 2 3:20
    Total HE 25% 7:30 Total HE 50% 5:20
    Total H Deducir 1:55

    Agradecere mucho si alguien me puede colaborar para resolver esto.

    Gracias de antemano
    Formula Para HE 25%
    Last edited by Joe4; Oct 11th, 2017 at 11:03 AM.

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com