{"id":16099,"date":"2024-05-30T15:57:37","date_gmt":"2024-05-30T19:57:37","guid":{"rendered":"https:\/\/excelfull.com\/excel\/?p=16099"},"modified":"2024-06-17T10:03:32","modified_gmt":"2024-06-17T14:03:32","slug":"como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/","title":{"rendered":"C\u00d3MO CALCULAR HORAS EXTRAS EN EXCEL: GU\u00cdA Y PLANTILLA GRATIS"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><span style=\"color: #136e42;\"><strong><u>TODO LO QUE NECESITAS SABER PARA CALCULAR HORAS EXTRAS EN EXCEL: PASOS, F\u00d3RMULAS Y PLANTILLA GRATIS<\/u><\/strong><\/span><\/p><div id=\"excel-3613055072\" class=\"excel-contenido_3 excel-entity-placement\"><section id=\"temario-blog\" class=\"py-8 bg-white\">\r\n    <div class=\"max-w-4xl mx-auto px-4\">\r\n        <div class=\"relative overflow-hidden bg-slate-900 rounded-[2rem] p-8 md:p-12 shadow-xl\">\r\n            \r\n            <div class=\"absolute top-0 right-0 -translate-y-1\/2 translate-x-1\/2 w-64 h-64 bg-[#136E42] opacity-20 blur-[80px] rounded-full\"><\/div>\r\n            <div class=\"absolute bottom-0 left-0 translate-y-1\/2 -translate-x-1\/2 w-48 h-48 bg-emerald-500 opacity-10 blur-[60px] rounded-full\"><\/div>\r\n\r\n            <div class=\"relative z-10 flex flex-col gap-8\">\r\n                \r\n                <div class=\"text-center\">\r\n                    <div class=\"inline-flex items-center gap-2 bg-white\/10 border border-white\/20 px-3 py-1.5 rounded-full mb-4\">\r\n                        <i class=\"fa-solid fa-file-pdf text-emerald-400 text-xs\"><\/i>\r\n                        <span class=\"text-white text-[9px] font-black uppercase tracking-[0.2em]\">Recurso Gratuito 2026<\/span>\r\n                    <\/div>\r\n                    <h2 class=\"text-2xl md:text-3xl font-extrabold text-white leading-tight mb-3\">\r\n                        \u00bfTe gustar\u00eda dominar <span class=\"text-emerald-400\">Excel como un Pro?<\/span>\r\n                    <\/h2>\r\n                    <p class=\"text-slate-300 text-base font-medium max-w-xl mx-auto\">\r\n                        Suscr\u00edbete para recibir tips exclusivos y descarga el temario completo de nuestro curso profesional en PDF.\r\n                    <\/p>\r\n                <\/div>\r\n\r\n                <div class=\"w-full max-w-md mx-auto bg-white\/5 backdrop-blur-sm border border-white\/10 p-6 rounded-2xl\">\r\n                    \r\n                    <div id=\"form-content-blog\">\r\n                        <form id=\"excel-form-blog\" class=\"space-y-4\">\r\n                            <div>\r\n                                <label for=\"email-blog\" class=\"block text-white\/70 text-[10px] font-bold uppercase tracking-widest mb-2 ml-1\">Tu mejor correo electr\u00f3nico<\/label>\r\n                                <input type=\"email\" id=\"email-blog\" name=\"email\" placeholder=\"ejemplo@correo.com\" required \r\n                                    class=\"w-full bg-white\/10 border border-white\/20 rounded-xl px-4 py-3.5 text-white placeholder:text-slate-500 focus:outline-none focus:ring-2 focus:ring-emerald-500\/50 transition-all text-sm\">\r\n                            <\/div>\r\n                            \r\n                            <button type=\"submit\" id=\"submit-btn-blog\"\r\n                                class=\"w-full bg-[#136E42] hover:bg-emerald-600 text-white py-4 rounded-xl text-xs font-black uppercase tracking-widest transition-all shadow-lg active:scale-95 flex items-center justify-center gap-3\">\r\n                                <span>Descargar Temario y Suscribirme<\/span>\r\n                                <i class=\"fa-solid fa-paper-plane text-[10px]\"><\/i>\r\n                            <\/button>\r\n                        <\/form>\r\n                        <p class=\"text-slate-500 text-[9px] text-center mt-4 font-bold uppercase tracking-widest\">\r\n                            <i class=\"fa-solid fa-shield-halved mr-1\"><\/i> Sin spam. Solo contenido de valor.\r\n                        <\/p>\r\n                    <\/div>\r\n\r\n                    <div id=\"success-message-blog\" class=\"hidden text-center py-4\">\r\n                        <div class=\"w-12 h-12 bg-emerald-500\/20 text-emerald-400 rounded-full flex items-center justify-center mx-auto mb-3 border border-emerald-500\/30\">\r\n                            <i class=\"fa-solid fa-check text-xl\"><\/i>\r\n                        <\/div>\r\n                        <h3 class=\"text-white text-lg font-bold mb-1\">\u00a1Registro completado!<\/h3>\r\n                        <p class=\"text-slate-400 text-xs leading-relaxed\">\r\n                            Revisa tu bandeja de entrada; el temario ya va en camino.\r\n                        <\/p>\r\n                    <\/div>\r\n                <\/div>\r\n\r\n            <\/div>\r\n        <\/div>\r\n    <\/div>\r\n<\/section>\r\n\r\n<script>\r\ndocument.getElementById('excel-form-blog').addEventListener('submit', function(e) {\r\n    e.preventDefault();\r\n    const btn = document.getElementById('submit-btn-blog');\r\n    const email = document.getElementById('email-blog').value;\r\n    const btnText = btn.querySelector('span');\r\n    \r\n    btn.disabled = true;\r\n    btn.classList.add('opacity-50', 'cursor-not-allowed');\r\n    btnText.innerText = 'PROCESANDO...';\r\n\r\n    fetch('https:\/\/n8n.george.com.py\/webhook\/registro-excel-full', {\r\n        method: 'POST',\r\n        headers: { 'Content-Type': 'application\/json' },\r\n        body: JSON.stringify({ \r\n            email: email,\r\n            origen: 'descarga_temario_blog'\r\n        })\r\n    })\r\n    .then(response => {\r\n        if(response.ok) {\r\n            \/\/ Empujamos el evento a GTM para medir conversiones desde el blog\r\n            window.dataLayer = window.dataLayer || [];\r\n            window.dataLayer.push({\r\n                event: 'form_blog_success',\r\n                form_name: 'captacion_blog',\r\n                email: email,\r\n                origen: 'descarga_temario_blog'\r\n            });\r\n\r\n            document.getElementById('form-content-blog').classList.add('hidden');\r\n            document.getElementById('success-message-blog').classList.remove('hidden');\r\n        } else {\r\n            throw new Error();\r\n        }\r\n    })\r\n    .catch(error => {\r\n        alert('Hubo un inconveniente. Intenta de nuevo.');\r\n        btn.disabled = false;\r\n        btn.classList.remove('opacity-50', 'cursor-not-allowed');\r\n        btnText.innerText = 'Descargar Temario y Suscribirme';\r\n    });\r\n});\r\n<\/script><\/div>\n<p>El <strong>c\u00e1lculo de horas extras<\/strong> es una tarea esencial en la gesti\u00f3n de recursos humanos y n\u00f3minas, ya que permite a las empresas compensar adecuadamente a los empleados por el tiempo trabajado fuera del horario regular. A continuaci\u00f3n, te explicamos qu\u00e9 son las horas extras, por qu\u00e9 es importante calcularlas y c\u00f3mo puedes hacerlo en Excel. Al final del art\u00edculo, encontrar\u00e1s una plantilla gratuita descargable para que puedas empezar de inmediato.<\/p>\n<h2>\u00bfQU\u00c9 SON LAS HORAS EXTRAS?<\/h2>\n<p>Las horas extras son aquellas horas trabajadas por un empleado que exceden la jornada laboral est\u00e1ndar acordada, que com\u00fanmente es de 40 horas semanales en muchos pa\u00edses. Estas horas adicionales suelen pagarse a una tasa m\u00e1s alta que las horas normales, como un 1.5 veces (tiempo y medio) o 2 veces (doble tiempo) la tasa regular.<\/p>\n<h2>\u00bfPOR QU\u00c9 ES IMPORTANTE CALCULAR LAS HORAS EXTRAS?<\/h2>\n<ul>\n<li><strong>Cumplimiento legal:<\/strong> Las leyes laborales a menudo requieren que las empresas paguen una tarifa premium por horas extras.<\/li>\n<li><strong>Compensaci\u00f3n justa:<\/strong> Garantiza que los empleados sean debidamente compensados por el tiempo adicional trabajado.<\/li>\n<li><strong>Moral del empleado:<\/strong> Un c\u00e1lculo y pago precisos de las horas extras pueden mejorar la satisfacci\u00f3n y motivaci\u00f3n de los empleados.<\/li>\n<li><strong>Control de costos:<\/strong> Ayuda a las empresas a gestionar y controlar los costos laborales adicionales.<\/li>\n<\/ul>\n<h2>C\u00d3MO CALCULAR HORAS EXTRAS EN EXCEL<\/h2>\n<p>Para calcular horas extras en Excel, necesitas registrar la hora de inicio y fin del trabajo de cada empleado y luego determinar las horas trabajadas y las horas extras. Aqu\u00ed tienes un paso a paso para lograrlo:<\/p>\n<h3 style=\"padding-left: 40px;\">PASO 1: PREPARAR LOS DATOS<\/h3>\n<p style=\"padding-left: 40px;\">Para iniciar con los c\u00e1lculos necesitaremos algunos datos fundamentales como las horas de entrada y salida para cada uno de los <a href=\"https:\/\/excelfull.com\/excel\/transforma-tu-manejo-de-fechas-y-horas-en-excel-funciones-avanzadas-y-aplicaciones-practicas\/\" target=\"_blank\" rel=\"noopener\"><strong>d\u00edas laborables<\/strong><\/a>, el horario en que se toma un descanso y a tarifa que deber\u00e1 pagarse por cada hora, ya sea en horario regular o como horas extras.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-16100\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/hs-extras-1.png\" alt=\"C\u00d3MO CALCULAR HORAS EXTRAS EN EXCEL: GU\u00cdA Y PLANTILLA GRATIS\" width=\"302\" height=\"353\" \/><\/p>\n<p style=\"padding-left: 40px;\">\n<p>&nbsp;<\/p>\n<h3 style=\"padding-left: 40px;\">PASO 2: CREAR LA PLANILLA<\/h3>\n<p style=\"padding-left: 40px;\">Aqu\u00ed tienes un ejemplo de c\u00f3mo estructurar tu hoja de c\u00e1lculo:<\/p>\n<p style=\"padding-left: 40px;\"><strong>Registrar las horas:<\/strong> Crea una tabla donde registres la hora de entrada y salida de cada empleado.<\/p>\n<p style=\"padding-left: 40px;\"><strong>Calcular las horas trabajadas:<\/strong> Resta la hora de entrada de la hora de salida.<\/p>\n<p style=\"padding-left: 40px;\"><strong>Determinar las horas regulares y extras:<\/strong> Define la jornada laboral est\u00e1ndar y calcula las horas extras.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter  wp-image-16101\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/hs-extras-2.png\" alt=\"\" width=\"738\" height=\"398\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/hs-extras-2.png 1186w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/hs-extras-2-1000x539.png 1000w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/hs-extras-2-768x414.png 768w\" sizes=\"auto, (max-width: 738px) 100vw, 738px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"padding-left: 40px;\">PASO 3: INSERTAR F\u00d3RMULAS Y FUNCIONES<\/h3>\n<p style=\"padding-left: 80px;\"><strong>A. CALCULAR LAS HORAS TRABAJADAS:<\/strong><\/p>\n<pre style=\"padding-left: 80px;\"><strong>=(G13-F13)+(E13-D13)<\/strong><\/pre>\n<p style=\"padding-left: 80px;\">Esta f\u00f3rmula determina la diferencia entre la hora de salida y el final del descanso, y luego suma esta diferencia con la cantidad de horas entre el inicio del descanso y la hora de entrada. Observa los resultados al aplicar esta f\u00f3rmula para cada d\u00eda:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter  wp-image-16102\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/hs-extras-3.png\" alt=\"\" width=\"749\" height=\"347\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/hs-extras-3.png 905w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/hs-extras-3-768x356.png 768w\" sizes=\"auto, (max-width: 749px) 100vw, 749px\" \/><\/p>\n<p style=\"padding-left: 80px;\">Con esto obtenemos las horas trabajadas cada d\u00eda y los c\u00e1lculos subsiguientes se basar\u00e1n en este valor.<\/p>\n<p style=\"padding-left: 80px;\">Aseg\u00farate de que las celdas est\u00e1n en formato de hora.<\/p>\n<p>&nbsp;<\/p>\n<p style=\"padding-left: 80px;\"><strong>B. DETERMINAR LAS HORAS REGULARES:<\/strong><\/p>\n<p style=\"padding-left: 80px;\">Hemos calculado el total de horas que deben trabajarse por d\u00eda en la celda M17, y para verificar si se ha cumplido esta cantidad de horas de trabajo cada d\u00eda, utilizaremos la <a href=\"https:\/\/excelfull.com\/excel\/la-funcion-si-en-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>funci\u00f3n SI<\/strong><\/a> para comparar el total de horas trabajadas, utilizando la siguiente f\u00f3rmula:<\/p>\n<pre style=\"padding-left: 80px;\"><strong>=SI(H13&gt;$M$17;$M$17;H13)<\/strong><\/pre>\n<p style=\"padding-left: 80px;\"><strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-16103\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/hs-extras-4.png\" alt=\"C\u00d3MO CALCULAR HORAS EXTRAS EN EXCEL: GU\u00cdA Y PLANTILLA GRATIS\" width=\"793\" height=\"268\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/hs-extras-4.png 1415w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/hs-extras-4-1000x339.png 1000w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/hs-extras-4-768x260.png 768w\" sizes=\"auto, (max-width: 793px) 100vw, 793px\" \/><br \/>\n<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p style=\"padding-left: 80px;\"><strong>C. DETERMINAR LAS HORAS EXTRAS:<\/strong><\/p>\n<p style=\"padding-left: 80px;\">El siguiente paso es calcular las horas extras, lo cual nuevamente ser\u00e1 una condici\u00f3n para verificar si la columna de Total de horas supera el m\u00ednimo requerido. La f\u00f3rmula que utilizaremos ser\u00e1 la siguiente:<\/p>\n<pre style=\"padding-left: 80px;\"><strong>=SI(H13&gt;$M$17;H13-$M$17;0)<\/strong><\/pre>\n<p style=\"padding-left: 80px;\"><strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter  wp-image-16104\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/hs-extras-5.png\" alt=\"\" width=\"807\" height=\"266\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/hs-extras-5.png 1516w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/hs-extras-5-1000x330.png 1000w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/hs-extras-5-768x253.png 768w\" sizes=\"auto, (max-width: 807px) 100vw, 807px\" \/><br \/>\n<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p style=\"padding-left: 80px;\"><strong>D. CALCULAR EL PAGO:<\/strong><\/p>\n<p style=\"padding-left: 80px;\">Para determinar el importe correspondiente a las horas regulares y las horas extras, se precisa transformarlas en una forma decimal aplicable para su multiplicaci\u00f3n con la tarifa correspondiente. Esta conversi\u00f3n se realiza multiplicando el total por 24.<\/p>\n<p style=\"padding-left: 80px;\">Una vez las horas est\u00e1n expresadas en forma decimal, solo resta multiplicarlas por las tarifas respectivas para obtener el total a abonar:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-16105\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/hs-extras-6.png\" alt=\"C\u00d3MO CALCULAR HORAS EXTRAS EN EXCEL: GU\u00cdA Y PLANTILLA GRATIS\" width=\"760\" height=\"272\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/hs-extras-6.png 1190w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/hs-extras-6-1000x358.png 1000w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/hs-extras-6-768x275.png 768w\" sizes=\"auto, (max-width: 760px) 100vw, 760px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>DESCARGAR PLANTILLA<\/h2>\n<p>Esta plantilla incluye columnas predefinidas para la fecha, hora de entrada, hora de salida, c\u00e1lculo autom\u00e1tico de horas trabajadas, horas regulares y horas extras. Simplemente descarga y comienza a usarla con tus datos.<\/p>\n<p style=\"padding-left: 40px;\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-15833 alignnone\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/05\/clic-e1715127123488.png\" alt=\"\" width=\"51\" height=\"51\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/05\/clic-e1715127123488.png 512w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/05\/clic-e1715127123488-150x150.png 150w\" sizes=\"auto, (max-width: 51px) 100vw, 51px\" \/>\u00a0 \u00a0<a href=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/Calculo-de-horas-extras-mensual.xlsx\" target=\"_blank\" rel=\"noopener\"><strong>DESCARGAR PLANTILLA DE C\u00c1LCULO DE HORAS EXTRAS<\/strong><\/a><\/p>\n<h2>CONCLUSI\u00d3N<\/h2>\n<p>Calcular horas extras en Excel no solo es esencial para cumplir con las regulaciones laborales y asegurar una compensaci\u00f3n justa, sino que tambi\u00e9n es una herramienta \u00fatil para la gesti\u00f3n eficiente del tiempo y los costos laborales en tu empresa. Usar Excel para esta tarea te proporciona flexibilidad y precisi\u00f3n en el manejo de los datos de horas trabajadas.<\/p>\n<p>Esperamos que este art\u00edculo y la plantilla te sean de ayuda para gestionar mejor las horas extras en tu organizaci\u00f3n. \u00a1<span style=\"color: #136e42;\"><strong>No dudes en compartir cualquier comentario o pregunta!<\/strong><\/span><\/p>\n<hr \/>\n<p><strong><span style=\"color: #136e42;\">\u00bb<\/span> Si te gustan nuestros blogs, comp\u00e1rtelo con tus amigos. Puedes seguirnos en <span style=\"color: #3366ff;\"><a style=\"color: #3366ff;\" href=\"https:\/\/www.facebook.com\/excelfull7\">Facebook<\/a><\/span> e <span style=\"color: #ff00ff;\"><a style=\"color: #ff00ff;\" href=\"https:\/\/www.instagram.com\/excelfull_oficial\/\">Instagram<\/a><\/span>.<\/strong><\/p>\n<p><strong><span style=\"color: #136e42;\">\u00bb<\/span> D\u00e9janos tu comentario al final de esta p\u00e1gina.<\/strong><\/p>\n<p><strong><span style=\"color: #136e42;\">\u00bb <\/span>Explora m\u00e1s sobre nosotros directo aqu\u00ed: <a href=\"https:\/\/excelfull.com\/\">Curso de Excel Online<\/a><\/strong><\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; TODO LO QUE NECESITAS &#8230; <a title=\"C\u00d3MO CALCULAR HORAS EXTRAS EN EXCEL: GU\u00cdA Y PLANTILLA GRATIS\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/\" aria-label=\"Leer m\u00e1s sobre C\u00d3MO CALCULAR HORAS EXTRAS EN EXCEL: GU\u00cdA Y PLANTILLA GRATIS\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":16112,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[328,549,571,556,568,742,859],"tags":[855,854,824],"class_list":["post-16099","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-excel-intermedio","category-de-fecha-y-hora","category-funciones-especiales","category-funciones-logicas","category-plantillas","category-recursos-humanos","tag-calcular-pago","tag-horas-extras","tag-plantilla","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>CALCULAR HORAS EXTRAS EN EXCEL - excelfull.com<\/title>\n<meta name=\"description\" content=\"Aprende a calcular horas extras en Excel con nuestra gu\u00eda paso a paso. Incluye f\u00f3rmulas esenciales y una plantilla gratuita para descargar.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CALCULAR HORAS EXTRAS EN EXCEL - excelfull.com\" \/>\n<meta property=\"og:description\" content=\"Aprende a calcular horas extras en Excel con nuestra gu\u00eda paso a paso. Incluye f\u00f3rmulas esenciales y una plantilla gratuita para descargar.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog de Excelfull\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelfull7\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-30T19:57:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-17T14:03:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/COMO-CALCULAR-HORAS-EXTRAS-EN-EXCEL-GUIA-Y-PLANTILLA-GRATIS.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Excelfull\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Excelfull\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"C\u00d3MO CALCULAR HORAS EXTRAS EN EXCEL: GU\u00cdA Y PLANTILLA GRATIS\",\"datePublished\":\"2024-05-30T19:57:37+00:00\",\"dateModified\":\"2024-06-17T14:03:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/\"},\"wordCount\":850,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/COMO-CALCULAR-HORAS-EXTRAS-EN-EXCEL-GUIA-Y-PLANTILLA-GRATIS.png\",\"keywords\":[\"calcular pago\",\"horas extras\",\"plantilla\"],\"articleSection\":[\"Excel\",\"Excel Intermedio\",\"Fecha y Hora\",\"Funciones Especiales\",\"L\u00f3gicas\",\"Plantillas\",\"Recursos Humanos\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/\",\"url\":\"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/\",\"name\":\"CALCULAR HORAS EXTRAS EN EXCEL - excelfull.com\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/COMO-CALCULAR-HORAS-EXTRAS-EN-EXCEL-GUIA-Y-PLANTILLA-GRATIS.png\",\"datePublished\":\"2024-05-30T19:57:37+00:00\",\"dateModified\":\"2024-06-17T14:03:32+00:00\",\"description\":\"Aprende a calcular horas extras en Excel con nuestra gu\u00eda paso a paso. Incluye f\u00f3rmulas esenciales y una plantilla gratuita para descargar.\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/COMO-CALCULAR-HORAS-EXTRAS-EN-EXCEL-GUIA-Y-PLANTILLA-GRATIS.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/COMO-CALCULAR-HORAS-EXTRAS-EN-EXCEL-GUIA-Y-PLANTILLA-GRATIS.png\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\/\/excelfull.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"C\u00d3MO CALCULAR HORAS EXTRAS EN EXCEL: GU\u00cdA Y PLANTILLA GRATIS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelfull.com\/excel\/#website\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"name\":\"Blog de Excelfull\",\"description\":\"Todo lo que necesitas saber sobre Excel\",\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"alternateName\":\"Blog Excel Online\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/excelfull.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\",\"name\":\"Nlog Excelfull\",\"alternateName\":\"Blog Excel En L\u00ednea\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"width\":1342,\"height\":341,\"caption\":\"Nlog Excelfull\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/excelfull7\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\",\"name\":\"Excelfull\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"caption\":\"Excelfull\"},\"url\":\"https:\/\/excelfull.com\/excel\/author\/ema\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"CALCULAR HORAS EXTRAS EN EXCEL - excelfull.com","description":"Aprende a calcular horas extras en Excel con nuestra gu\u00eda paso a paso. Incluye f\u00f3rmulas esenciales y una plantilla gratuita para descargar.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/","og_locale":"es_ES","og_type":"article","og_title":"CALCULAR HORAS EXTRAS EN EXCEL - excelfull.com","og_description":"Aprende a calcular horas extras en Excel con nuestra gu\u00eda paso a paso. Incluye f\u00f3rmulas esenciales y una plantilla gratuita para descargar.","og_url":"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2024-05-30T19:57:37+00:00","article_modified_time":"2024-06-17T14:03:32+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/COMO-CALCULAR-HORAS-EXTRAS-EN-EXCEL-GUIA-Y-PLANTILLA-GRATIS.png","type":"image\/png"}],"author":"Excelfull","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Excelfull","Tiempo de lectura":"6 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"C\u00d3MO CALCULAR HORAS EXTRAS EN EXCEL: GU\u00cdA Y PLANTILLA GRATIS","datePublished":"2024-05-30T19:57:37+00:00","dateModified":"2024-06-17T14:03:32+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/"},"wordCount":850,"commentCount":1,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/COMO-CALCULAR-HORAS-EXTRAS-EN-EXCEL-GUIA-Y-PLANTILLA-GRATIS.png","keywords":["calcular pago","horas extras","plantilla"],"articleSection":["Excel","Excel Intermedio","Fecha y Hora","Funciones Especiales","L\u00f3gicas","Plantillas","Recursos Humanos"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/","url":"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/","name":"CALCULAR HORAS EXTRAS EN EXCEL - excelfull.com","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/COMO-CALCULAR-HORAS-EXTRAS-EN-EXCEL-GUIA-Y-PLANTILLA-GRATIS.png","datePublished":"2024-05-30T19:57:37+00:00","dateModified":"2024-06-17T14:03:32+00:00","description":"Aprende a calcular horas extras en Excel con nuestra gu\u00eda paso a paso. Incluye f\u00f3rmulas esenciales y una plantilla gratuita para descargar.","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/#primaryimage","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/COMO-CALCULAR-HORAS-EXTRAS-EN-EXCEL-GUIA-Y-PLANTILLA-GRATIS.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/06\/COMO-CALCULAR-HORAS-EXTRAS-EN-EXCEL-GUIA-Y-PLANTILLA-GRATIS.png","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/como-calcular-horas-extras-en-excel-guia-y-plantilla-gratis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inicio","item":"https:\/\/excelfull.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel","item":"https:\/\/excelfull.com\/excel\/excel\/"},{"@type":"ListItem","position":3,"name":"C\u00d3MO CALCULAR HORAS EXTRAS EN EXCEL: GU\u00cdA Y PLANTILLA GRATIS"}]},{"@type":"WebSite","@id":"https:\/\/excelfull.com\/excel\/#website","url":"https:\/\/excelfull.com\/excel\/","name":"Blog de Excelfull","description":"Todo lo que necesitas saber sobre Excel","publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"alternateName":"Blog Excel Online","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/excelfull.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/excelfull.com\/excel\/#organization","name":"Nlog Excelfull","alternateName":"Blog Excel En L\u00ednea","url":"https:\/\/excelfull.com\/excel\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","width":1342,"height":341,"caption":"Nlog Excelfull"},"image":{"@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelfull7"]},{"@type":"Person","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801","name":"Excelfull","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","caption":"Excelfull"},"url":"https:\/\/excelfull.com\/excel\/author\/ema\/"}]}},"_links":{"self":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/16099","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/comments?post=16099"}],"version-history":[{"count":7,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/16099\/revisions"}],"predecessor-version":[{"id":16114,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/16099\/revisions\/16114"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media\/16112"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=16099"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=16099"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=16099"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}