Formulas Para Tabla de Horas

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

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 12:03 PM.

  2. #2
    Board Regular
    Join Date
    Jul 2014
    Posts
    315
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formulas Para Tabla de Horas

      
    Creo que esto deberia de funcionar

    Excel 2012
    HIJK
    1EntradaSalidaHE 25%HE 50%
    28:0017:000.000
    38:0019:002.000
    48:0021:0031
    58:0016:00-1.000
    68:0018:301.500
    78:1517:00-0.250
    88:4017:00-0.670
    98:0022:2032.33333333

    Hoja1



    Worksheet Formulas
    CellFormula
    J2=IF((I2*24)>=19.1,"3",((I2*24)-(H2*24)-9))
    K2=((I2*24)-(H2*24)-9-(J2))
    J3=IF((I3*24)>=19.1,"3",((I3*24)-(H3*24)-9))
    K3=((I3*24)-(H3*24)-9-(J3))
    J4=IF((I4*24)>=19.1,"3",((I4*24)-(H4*24)-9))
    K4=((I4*24)-(H4*24)-9-(J4))
    J5=IF((I5*24)>=19.1,"3",((I5*24)-(H5*24)-9))
    K5=((I5*24)-(H5*24)-9-(J5))
    J6=IF((I6*24)>=19.1,"3",((I6*24)-(H6*24)-9))
    K6=((I6*24)-(H6*24)-9-(J6))
    J7=IF((I7*24)>=19.1,"3",((I7*24)-(H7*24)-9))
    K7=((I7*24)-(H7*24)-9-(J7))
    J8=IF((I8*24)>=19.1,"3",((I8*24)-(H8*24)-9))
    K8=((I8*24)-(H8*24)-9-(J8))
    J9=IF((I9*24)>=19.1,"3",((I9*24)-(H9*24)-9))
    K9=((I9*24)-(H9*24)-9-(J9))

    Last edited by Truiz; Oct 23rd, 2017 at 07:18 PM.

    - forum use guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

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