{"id":14235,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/hora\/"},"modified":"2021-02-26T08:59:59","modified_gmt":"2021-02-26T08:59:59","slug":"time","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/time\/","title":{"rendered":"HORA"},"content":{"rendered":"

Descripci\u00f3n y Sintaxis<\/h2>\n

La funci\u00f3n HORA en Excel y Google Sheets convierte una hora espec\u00edfica en un n\u00famero serial, representando una fracci\u00f3n del d\u00eda desde la medianoche. Esta funcionalidad es esencial para realizar c\u00e1lculos con tiempos en ambos programas. Su sintaxis es la siguiente:<\/p>\n

HORA(hora, minuto, segundo)<\/code><\/pre>\n
    \n
  • hora<\/strong>: Valor num\u00e9rico que representa la hora del d\u00eda. Debe estar entre 0 y 23.<\/li>\n
  • minuto<\/strong>: Valor num\u00e9rico que representa los minutos. Debe estar entre 0 y 59.<\/li>\n
  • segundo<\/strong>: Valor num\u00e9rico que representa los segundos. Debe estar entre 0 y 59.<\/li>\n<\/ul>\n
    Ejemplo de uso:<\/p>\n
    =HORA(13, 30, 55)<\/code><\/pre>\n
    Este ejemplo genera un n\u00famero serial que corresponde a las 1:30 PM y 55 segundos.<\/p>\n
    Aplicaciones Pr\u00e1cticas<\/h2>\n
    La funci\u00f3n HORA puede ser extremadamente \u00fatil en una variedad de contextos, desde la organizaci\u00f3n de horarios laborales hasta la gesti\u00f3n de eventos. A continuaci\u00f3n, se ofrecen ejemplos pr\u00e1cticos de c\u00f3mo aplicar esta funci\u00f3n eficazmente.<\/p>\n
    Caso Pr\u00e1ctico: Programaci\u00f3n de Turnos de Trabajadores<\/h2>\n
    Supongamos que necesitamos crear una tabla para planificar el inicio y fin de cada turno laboral y calcular la duraci\u00f3n total. La funci\u00f3n HORA facilita la manipulaci\u00f3n y c\u00e1lculo de estos tiempos.<\/p>\n\n\n\n\n
    Empleado<\/th>\nHora de Entrada<\/th>\nHora de Salida<\/th>\nDuraci\u00f3n del Turno<\/th>\n<\/tr>\n
    Juan P\u00e9rez<\/td>\n=HORA(8, 0, 0)<\/td>\n=HORA(16, 0, 0)<\/td>\n=HORA(16, 0, 0) – HORA(8, 0, 0)<\/td>\n<\/tr>\n
    Maria L\u00f3pez<\/td>\n=HORA(9, 30, 0)<\/td>\n=HORA(17, 30, 0)<\/td>\n=HORA(17, 30, 0) – HORA(9, 30, 0)<\/td>\n<\/tr>\n<\/table>\n
    En la columna \u00abDuraci\u00f3n del Turno\u00bb, calculamos cu\u00e1ntas horas trabaj\u00f3 cada empleado, simplificando el proceso de c\u00e1lculo de horas laborales.<\/p>\n
    Caso Pr\u00e1ctico: Planificaci\u00f3n de Eventos<\/h2>\n
    Supongamos que est\u00e1s organizando un evento y necesitas programar los horarios de inicio y fin de las actividades para asegurar que no se solapen.<\/p>\n
    =HORA(10, 0, 0) \/\/ Inicio de la Conferencia =HORA(12, 0, 0) \/\/ Fin de la Conferencia =HORA(12, 30, 0) \/\/ Inicio del Almuerzo =HORA(14, 0, 0) \/\/ Fin del Almuerzo<\/code><\/pre>\n
    Al visualizar estas horas en un cronograma, la organizaci\u00f3n del tiempo y la coordinaci\u00f3n entre actividades se vuelven m\u00e1s claras y manejables.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve el n\u00famero de serie correspondiente a una hora determinada<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[546],"tags":[],"class_list":["post-14235","post","type-post","status-publish","format-standard","hentry","category-fecha-y-hora"],"acf":[],"yoast_head":"\nFunci\u00f3n TIME (HORA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n TIME (HORA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/es\/time\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n TIME (HORA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n TIME (HORA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/time\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:59:59+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n TIME (HORA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/es\/time\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/time\/\",\"name\":\"Funci\u00f3n TIME (HORA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:59:59+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n TIME (HORA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/time\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/time\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/time\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fecha y hora\",\"item\":\"https:\/\/functiontranslator.com\/es\/fecha-y-hora\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"HORA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n TIME (HORA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n TIME (HORA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","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:\/\/functiontranslator.com\/es\/time\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n TIME (HORA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n TIME (HORA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/time\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:59:59+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n TIME (HORA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/time\/","url":"https:\/\/functiontranslator.com\/es\/time\/","name":"Funci\u00f3n TIME (HORA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:59:59+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n TIME (HORA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/time\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/time\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/time\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Fecha y hora","item":"https:\/\/functiontranslator.com\/es\/fecha-y-hora\/"},{"@type":"ListItem","position":3,"name":"HORA"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14235","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=14235"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14235\/revisions"}],"predecessor-version":[{"id":30364,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14235\/revisions\/30364"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}