fbpx

Control de asistencia en Excel (control de ingreso y salida en tiempo real)

-->

Control de asistencia en excelControl de asistencia en Excel (en tiempo real)  es un archivo desarrollado con la ayuda de macros, que nos permite capturar el momento preciso en que un trabajador hace su ingreso a su centro de labores, de igual forma cuando este marca su salida, su caraterística principal es que lo hace en tiempo real lo que nos permitirá facilmente detectar si este llegó tarde, no asistió o hizo horas extras, es una forma básica de controlar que tan puntuales son tus trabajadores pero puede ser el inicio de un gran proyecto.

Este archivo excel contiene dos hojas, una llamada «Empleados» en la cual debes listar a todos los trabajadores que estarán bajo este control, debo aclararte que basta con ingresar un «empleado» más y la base de datos se actualiza automáticamente, en la columna «E» debes desplazar una formula para obtener una concatenación de los apellidos y nombres.

base de datos de trabajadores en excel

La otra hoja de nombre «registro» es la que nos permitirá capturar el momento de ingreso y salida de los empleados, basta con seleccionar el nombre del trabajador y dependiendo de la acción quedará registrado.

control de asistencia en excel para empresas

DESCARGA

Descargar control de asistencias en tiempo real en Excel.xls

Fuente: Emagister Foro de Excel

Agrega tu comentario

Comentarios
  1. Posted by CRISTHIAN
    • Posted by Gustavo A. Sebastiani Cépeda
  2. Posted by Olivia
    • Posted by Gustavo A. Sebastiani Cépeda
  3. Posted by ADELIO CHUQUIMIA
    • Posted by Gustavo A. Sebastiani Cépeda
  4. Posted by antonio hernandez
    • Posted by Gustavo A. Sebastiani Cépeda
  5. Posted by Johanna Flores
    • Posted by Gustavo A. Sebastiani Cépeda
  6. Posted by Mario
    • Posted by Gustavo A. Sebastiani Cépeda
  7. Posted by SAUL
    • Posted by Gustavo A. Sebastiani Cépeda
  8. Posted by Jesus Alberto Aguilar
    • Posted by Gustavo A. Sebastiani Cépeda
  9. Posted by Mariana Rios
    • Posted by Gustavo A. Sebastiani Cépeda
  10. Posted by Rubén Andrade Torres
    • Posted by Gustavo A. Sebastiani Cépeda
  11. Posted by Pamela
    • Posted by Gustavo A. Sebastiani Cépeda
  12. Posted by rosmery solis
    • Posted by Gustavo A. Sebastiani Cépeda
  13. Posted by Jimena
    • Posted by Gustavo A. Sebastiani Cépeda
  14. Posted by Juan Torres
    • Posted by Gustavo A. Sebastiani Cépeda
  15. Posted by jhon
  16. Posted by jacky
  17. Posted by Juan torres
    • Posted by Gustavo A. Sebastiani Cépeda
  18. Posted by Max Seye
    • Posted by Max Seye
      • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by Gustavo A. Sebastiani Cépeda
  19. Posted by jhon mendes alva
    • Posted by Gustavo A. Sebastiani Cépeda
  20. Posted by Enviar ami correo porfa [email protected]
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Alma
        • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by JOHN
        • Posted by Gustavo A. Sebastiani Cépeda
  21. Posted by agustin espadas
    • Posted by Gustavo A. Sebastiani Cépeda
  22. Posted by carlos
    • Posted by Gustavo A. Sebastiani Cépeda
  23. Posted by CRISTOBAL CUELLAR CUELLAR
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by samanta
        • Posted by Gustavo A. Sebastiani Cépeda
  24. Posted by nicolas
    • Posted by Gustavo A. Sebastiani Cépeda
  25. Posted by KATTELINA
    • Posted by Gustavo A. Sebastiani Cépeda
  26. Posted by Orlando Zambrano
    • Posted by Gustavo A. Sebastiani Cépeda
  27. Posted by Patricio
    • Posted by Gustavo A. Sebastiani Cépeda
  28. Posted by Victor Manuel Ramírez Cabrera
    • Posted by Gustavo A. Sebastiani Cépeda
  29. Posted by joselyn
    • Posted by Gustavo A. Sebastiani Cépeda
  30. Posted by Keoba
    • Posted by Gustavo A. Sebastiani Cépeda
  31. Posted by JANET
    • Posted by Gustavo A. Sebastiani Cépeda
  32. Posted by PEDRO AGUSTO SIMBALA ROSALES
    • Posted by Gustavo A. Sebastiani Cépeda
  33. Posted by Manuel
    • Posted by Gustavo A. Sebastiani Cépeda
  34. Posted by Patricia
    • Posted by Gustavo A. Sebastiani Cépeda
  35. Posted by lucero
    • Posted by Gustavo A. Sebastiani Cépeda
  36. Posted by roberto ahumada
    • Posted by Gustavo A. Sebastiani Cépeda
  37. Posted by Cristhian
    • Posted by Gustavo A. Sebastiani Cépeda
  38. Posted by Pedro Muñoz
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Tania Gallegos
        • Posted by Gustavo A. Sebastiani Cépeda
  39. Posted by mario
    • Posted by Gustavo A. Sebastiani Cépeda
  40. Posted by Martin Quispe Puga
    • Posted by Gustavo A. Sebastiani Cépeda
  41. Posted by Juanita
    • Posted by Gustavo A. Sebastiani Cépeda
  42. Posted by MADELAINE LUZARDO
    • Posted by Gustavo A. Sebastiani Cépeda
  43. Posted by Jesus Olan
    • Posted by Gustavo A. Sebastiani Cépeda
  44. Posted by ALBERTO COLMENAREZ
    • Posted by Gustavo A. Sebastiani Cépeda
  45. Posted by NATANAEL FRANCISCO SALAS CHIMAL
    • Posted by Gustavo A. Sebastiani Cépeda
  46. Posted by MIGUEL CORRALES
    • Posted by Gustavo A. Sebastiani Cépeda
  47. Posted by Karl Carrillo
    • Posted by Gustavo A. Sebastiani Cépeda
  48. Posted by Jen Jai
    • Posted by Gustavo A. Sebastiani Cépeda
  49. Posted by anthony enrique concha mendoza
    • Posted by Gustavo A. Sebastiani Cépeda
  50. Posted by Alberto Reynoso
  51. Posted by KAIZEN
  52. Posted by Jerson Navarro
  53. Posted by eduardo
  54. Posted by Francisco Godiño
  55. Posted by jose
  56. Posted by AMERICO
  57. Posted by Samuel Hernández
    • Posted by Robin Solano
  58. Posted by Fernando Solis
  59. Posted by Antony
  60. Posted by FERNANDO GONZALEZ
    • Posted by Robin Solano
      • Posted by silvio
  61. Posted by EUMEY
  62. Posted by Eduin
  63. Posted by ESTALIN
    • Posted by Robin Solano
  64. Posted by Reyes Me.doza
    • Posted by Gustavo A. Sebastiani Cépeda
  65. Posted by Brandol
    • Posted by Gustavo A. Sebastiani Cépeda
  66. Posted by LISSET
    • Posted by Gustavo A. Sebastiani Cépeda
  67. Posted by gimmer renzo
    • Posted by Gustavo A. Sebastiani Cépeda
  68. Posted by Leonardo Carvallo
  69. Posted by EDUARDO
    • Posted by Gustavo A. Sebastiani Cépeda
  70. Posted by EDUARDO
  71. Posted by albert
    • Posted by Gustavo A. Sebastiani Cépeda
  72. Posted by karen
    • Posted by Gustavo A. Sebastiani Cépeda
  73. Posted by Reinaldo Gonzales
    • Posted by Gustavo A. Sebastiani Cépeda
  74. Posted by fede
  75. Posted by kevin
  76. Posted by sheinou
    • Posted by Gustavo A. Sebastiani Cépeda
  77. Posted by Isela
    • Posted by Gustavo A. Sebastiani Cépeda
  78. Posted by Andres
    • Posted by Gustavo A. Sebastiani Cépeda
  79. Posted by Diego
    • Posted by Gustavo A. Sebastiani Cépeda
  80. Posted by CAROLINA
    • Posted by Gustavo A. Sebastiani Cépeda
  81. Posted by GERMAN
    • Posted by Gustavo A. Sebastiani Cépeda
  82. Posted by Paulina Méndez
    • Posted by Gustavo A. Sebastiani Cépeda
  83. Posted by Emmanuel
    • Posted by Gustavo A. Sebastiani Cépeda
  84. Posted by lizbeth soto
    • Posted by Gustavo A. Sebastiani Cépeda
  85. Posted by alexander
  86. Posted by bag
  87. Posted by Manuel Zavala
  88. Posted by alexander hidalgo
  89. Posted by Harold
    • Posted by Gustavo A. Sebastiani Cépeda
  90. Posted by Joan
  91. Posted by luis
  92. Posted by Christian
  93. Posted by JORGE FAILOC
  94. Posted by jaiimeibarra
  95. Posted by Ronald
  96. Posted by Dorian
  97. Posted by alejandro
  98. Posted by Carlos Flores
    • Posted by Gustavo A. Sebastiani Cépeda
  99. Posted by solange
    • Posted by Gustavo A. Sebastiani Cépeda
  100. Posted by martha pineda
    • Posted by Gustavo A. Sebastiani Cépeda
  101. Posted by Carlos
    • Posted by Carlos
  102. Posted by CARLOS MARIO LOPEZ CASTAÑO
  103. Posted by ROBER
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by guido
  104. Posted by Yuri Gary Mollinedo Montaño
    • Posted by Gustavo A. Sebastiani Cépeda
  105. Posted by JHEISON
  106. Posted by HECTOR CH.S.
  107. Posted by Rolando Guevara
  108. Posted by Manuel
  109. Posted by Héctor López García
  110. Posted by Conito
  111. Posted by carmen
  112. Posted by José
  113. Posted by Ricardo
    • Posted by EDUARDO
  114. Posted by Lucas Ratti
    • Posted by Rodrigo
      • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by Giovanny
      • Posted by Luis
  115. Posted by Rolando
  116. Posted by Maria Constanza Bonilla Aponte
  117. Posted by Karla Sanchez
  118. Posted by Luis
  119. Posted by Alcides Hernandez
  120. Posted by Helena
  121. Posted by omar olvera
  122. Posted by rodrigo
  123. Posted by MANUEL ZAPATA CALDERON
  124. Posted by Jose
  125. Posted by oskar
  126. Posted by julio cesar
  127. Posted by Juan
    • Posted by gurulandio
  128. Posted by MARIA RONDON
  129. Posted by Cursos Excel
  130. Posted by mafelinda