{"id":1950,"date":"2014-08-18T05:19:39","date_gmt":"2014-08-18T05:19:39","guid":{"rendered":"http:\/\/www.abrima.com\/blog\/?p=1950"},"modified":"2020-04-18T15:12:03","modified_gmt":"2020-04-18T15:12:03","slug":"actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive","status":"publish","type":"post","link":"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/","title":{"rendered":"Actualizaci\u00f3n autom\u00e1tica de fecha y hora en hoja de calculo de Google Drive"},"content":{"rendered":"<div style=\"color: #666666;\">Esta funci\u00f3n nos permitir\u00e1 tener actualizada la hora y la fecha\u00a0en la Hoja de c\u00e1lculo\u00a0cada vez que se guarde un cambio.<br \/>\n<a name=\"more\"><\/a><\/div>\n<div style=\"color: #666666;\">Para logar esto, tenemos dos alternativas:<\/div>\n<div style=\"color: #666666;\"><\/div>\n<ul style=\"color: #666666;\">\n<li><i>=Now()<\/i>\u00a0nos permite tener fecha y hora actualizada.<\/li>\n<\/ul>\n<div class=\"separator\" style=\"color: #666666;\"><a style=\"color: #666666;\" href=\"http:\/\/1.bp.blogspot.com\/-JRndT-2rX0k\/U_DCgKsofZI\/AAAAAAAAUzk\/Rc4C4GjPPdw\/s1600\/dateupdate1.png\"><img src=\"http:\/\/1.bp.blogspot.com\/-JRndT-2rX0k\/U_DCgKsofZI\/AAAAAAAAUzk\/Rc4C4GjPPdw\/s1600\/dateupdate1.png\" alt=\"\" border=\"0\" \/><\/a><\/div>\n<div style=\"color: #666666;\"><\/div>\n<ul style=\"color: #666666;\">\n<li><i>=Today()<\/i>\u00a0nos permite tener solo fecha actualizada.<\/li>\n<\/ul>\n<div class=\"separator\" style=\"color: #666666;\"><a style=\"color: #666666;\" href=\"http:\/\/3.bp.blogspot.com\/-4Vm9VlI2Lk4\/U_DC-monL6I\/AAAAAAAAUzs\/8yysQKOY7Ro\/s1600\/dateupdate2.png\"><img src=\"http:\/\/3.bp.blogspot.com\/-4Vm9VlI2Lk4\/U_DC-monL6I\/AAAAAAAAUzs\/8yysQKOY7Ro\/s1600\/dateupdate2.png\" alt=\"\" border=\"0\" \/><\/a><\/div>\n<p>Abrima es partner de G Suite, mas detalles\u00a0<a href=\"https:\/\/www.abrima.com\/g-suite\">https:\/\/www.abrima.com\/g-suite<\/a><\/p>\n<p>Si quieres contratar cuentas G Suite entra a\u00a0<a href=\"https:\/\/refergsuite.app.goo.gl\/M1So\">https:\/\/refergsuite.app.goo.gl\/M1So<\/a><\/p>\n<p>Fuente: <a href=\"http:\/\/drivelatam.blogspot.com\/2014\/08\/actualizacion-automatica-de-fecha-y-hora.html\">Google Drive en Espa\u00f1ol<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Esta funci\u00f3n nos permitir\u00e1 tener actualizada la hora y la fecha\u00a0en la Hoja de c\u00e1lculo\u00a0cada vez que se guarde un cambio. Para logar esto, tenemos [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Actualizaci\u00f3n autom\u00e1tica de fecha y hora en hoja de calculo de Google Drive - Blog de Tecnolog\u00eda - Abrima<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Actualizaci\u00f3n autom\u00e1tica de fecha y hora en hoja de calculo de Google Drive - Blog de Tecnolog\u00eda - Abrima\" \/>\n<meta property=\"og:description\" content=\"Esta funci\u00f3n nos permitir\u00e1 tener actualizada la hora y la fecha\u00a0en la Hoja de c\u00e1lculo\u00a0cada vez que se guarde un cambio. Para logar esto, tenemos [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog de Tecnolog\u00eda - Abrima\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/abrimawebs\/\" \/>\n<meta property=\"article:published_time\" content=\"2014-08-18T05:19:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-18T15:12:03+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/1.bp.blogspot.com\/-JRndT-2rX0k\/U_DCgKsofZI\/AAAAAAAAUzk\/Rc4C4GjPPdw\/s1600\/dateupdate1.png\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Abrima\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.abrima.com\/blog\/#organization\",\"name\":\"Abrima\",\"url\":\"https:\/\/www.abrima.com\/blog\/\",\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/abrima-soluciones-web\/\",\"https:\/\/www.youtube.com\/user\/abrimawebs\",\"https:\/\/www.facebook.com\/abrimawebs\/\",\"https:\/\/twitter.com\/abrimaweb\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.abrima.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.abrima.com\/blog\/wp-content\/uploads\/2018\/03\/abrima-logo.png\",\"contentUrl\":\"https:\/\/www.abrima.com\/blog\/wp-content\/uploads\/2018\/03\/abrima-logo.png\",\"width\":700,\"height\":700,\"caption\":\"Abrima\"},\"image\":{\"@id\":\"https:\/\/www.abrima.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.abrima.com\/blog\/#website\",\"url\":\"https:\/\/www.abrima.com\/blog\/\",\"name\":\"Blog de Tecnolog\u00eda - Abrima\",\"description\":\"Blog sobre todo lo relacionado con Cloud, Marketing Digital y Web\",\"publisher\":{\"@id\":\"https:\/\/www.abrima.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.abrima.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"es\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/#primaryimage\",\"url\":\"http:\/\/1.bp.blogspot.com\/-JRndT-2rX0k\/U_DCgKsofZI\/AAAAAAAAUzk\/Rc4C4GjPPdw\/s1600\/dateupdate1.png\",\"contentUrl\":\"http:\/\/1.bp.blogspot.com\/-JRndT-2rX0k\/U_DCgKsofZI\/AAAAAAAAUzk\/Rc4C4GjPPdw\/s1600\/dateupdate1.png\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/#webpage\",\"url\":\"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/\",\"name\":\"Actualizaci\u00f3n autom\u00e1tica de fecha y hora en hoja de calculo de Google Drive - Blog de Tecnolog\u00eda - Abrima\",\"isPartOf\":{\"@id\":\"https:\/\/www.abrima.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/#primaryimage\"},\"datePublished\":\"2014-08-18T05:19:39+00:00\",\"dateModified\":\"2020-04-18T15:12:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/www.abrima.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Actualizaci\u00f3n autom\u00e1tica de fecha y hora en hoja de calculo de Google Drive\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/#webpage\"},\"author\":{\"@id\":\"https:\/\/www.abrima.com\/blog\/#\/schema\/person\/b768d5411164cb8b8d58f72cdf4e11e8\"},\"headline\":\"Actualizaci\u00f3n autom\u00e1tica de fecha y hora en hoja de calculo de Google Drive\",\"datePublished\":\"2014-08-18T05:19:39+00:00\",\"dateModified\":\"2020-04-18T15:12:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/#webpage\"},\"wordCount\":95,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\/\/www.abrima.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/1.bp.blogspot.com\/-JRndT-2rX0k\/U_DCgKsofZI\/AAAAAAAAUzk\/Rc4C4GjPPdw\/s1600\/dateupdate1.png\",\"articleSection\":[\"Google Apps\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/#respond\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.abrima.com\/blog\/#\/schema\/person\/b768d5411164cb8b8d58f72cdf4e11e8\",\"name\":\"Abrima\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.abrima.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5cc72c9c6b371583c943a070dff20409?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5cc72c9c6b371583c943a070dff20409?s=96&d=mm&r=g\",\"caption\":\"Abrima\"},\"url\":\"https:\/\/www.abrima.com\/blog\/author\/abrima\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Actualizaci\u00f3n autom\u00e1tica de fecha y hora en hoja de calculo de Google Drive - Blog de Tecnolog\u00eda - Abrima","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:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/","og_locale":"es_ES","og_type":"article","og_title":"Actualizaci\u00f3n autom\u00e1tica de fecha y hora en hoja de calculo de Google Drive - Blog de Tecnolog\u00eda - Abrima","og_description":"Esta funci\u00f3n nos permitir\u00e1 tener actualizada la hora y la fecha\u00a0en la Hoja de c\u00e1lculo\u00a0cada vez que se guarde un cambio. Para logar esto, tenemos [&hellip;]","og_url":"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/","og_site_name":"Blog de Tecnolog\u00eda - Abrima","article_publisher":"https:\/\/www.facebook.com\/abrimawebs\/","article_published_time":"2014-08-18T05:19:39+00:00","article_modified_time":"2020-04-18T15:12:03+00:00","og_image":[{"url":"http:\/\/1.bp.blogspot.com\/-JRndT-2rX0k\/U_DCgKsofZI\/AAAAAAAAUzk\/Rc4C4GjPPdw\/s1600\/dateupdate1.png"}],"twitter_misc":{"Escrito por":"Abrima"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/www.abrima.com\/blog\/#organization","name":"Abrima","url":"https:\/\/www.abrima.com\/blog\/","sameAs":["https:\/\/www.linkedin.com\/company\/abrima-soluciones-web\/","https:\/\/www.youtube.com\/user\/abrimawebs","https:\/\/www.facebook.com\/abrimawebs\/","https:\/\/twitter.com\/abrimaweb"],"logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.abrima.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.abrima.com\/blog\/wp-content\/uploads\/2018\/03\/abrima-logo.png","contentUrl":"https:\/\/www.abrima.com\/blog\/wp-content\/uploads\/2018\/03\/abrima-logo.png","width":700,"height":700,"caption":"Abrima"},"image":{"@id":"https:\/\/www.abrima.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/www.abrima.com\/blog\/#website","url":"https:\/\/www.abrima.com\/blog\/","name":"Blog de Tecnolog\u00eda - Abrima","description":"Blog sobre todo lo relacionado con Cloud, Marketing Digital y Web","publisher":{"@id":"https:\/\/www.abrima.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.abrima.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"es"},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/#primaryimage","url":"http:\/\/1.bp.blogspot.com\/-JRndT-2rX0k\/U_DCgKsofZI\/AAAAAAAAUzk\/Rc4C4GjPPdw\/s1600\/dateupdate1.png","contentUrl":"http:\/\/1.bp.blogspot.com\/-JRndT-2rX0k\/U_DCgKsofZI\/AAAAAAAAUzk\/Rc4C4GjPPdw\/s1600\/dateupdate1.png"},{"@type":"WebPage","@id":"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/#webpage","url":"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/","name":"Actualizaci\u00f3n autom\u00e1tica de fecha y hora en hoja de calculo de Google Drive - Blog de Tecnolog\u00eda - Abrima","isPartOf":{"@id":"https:\/\/www.abrima.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/#primaryimage"},"datePublished":"2014-08-18T05:19:39+00:00","dateModified":"2020-04-18T15:12:03+00:00","breadcrumb":{"@id":"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.abrima.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Actualizaci\u00f3n autom\u00e1tica de fecha y hora en hoja de calculo de Google Drive"}]},{"@type":"Article","@id":"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/#article","isPartOf":{"@id":"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/#webpage"},"author":{"@id":"https:\/\/www.abrima.com\/blog\/#\/schema\/person\/b768d5411164cb8b8d58f72cdf4e11e8"},"headline":"Actualizaci\u00f3n autom\u00e1tica de fecha y hora en hoja de calculo de Google Drive","datePublished":"2014-08-18T05:19:39+00:00","dateModified":"2020-04-18T15:12:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/#webpage"},"wordCount":95,"commentCount":4,"publisher":{"@id":"https:\/\/www.abrima.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/#primaryimage"},"thumbnailUrl":"http:\/\/1.bp.blogspot.com\/-JRndT-2rX0k\/U_DCgKsofZI\/AAAAAAAAUzk\/Rc4C4GjPPdw\/s1600\/dateupdate1.png","articleSection":["Google Apps"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.abrima.com\/blog\/actualizacion-automatica-de-fecha-y-hora-en-hoja-de-calculo-de-google-drive\/#respond"]}]},{"@type":"Person","@id":"https:\/\/www.abrima.com\/blog\/#\/schema\/person\/b768d5411164cb8b8d58f72cdf4e11e8","name":"Abrima","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.abrima.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5cc72c9c6b371583c943a070dff20409?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5cc72c9c6b371583c943a070dff20409?s=96&d=mm&r=g","caption":"Abrima"},"url":"https:\/\/www.abrima.com\/blog\/author\/abrima\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.abrima.com\/blog\/wp-json\/wp\/v2\/posts\/1950"}],"collection":[{"href":"https:\/\/www.abrima.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.abrima.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.abrima.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.abrima.com\/blog\/wp-json\/wp\/v2\/comments?post=1950"}],"version-history":[{"count":2,"href":"https:\/\/www.abrima.com\/blog\/wp-json\/wp\/v2\/posts\/1950\/revisions"}],"predecessor-version":[{"id":8427,"href":"https:\/\/www.abrima.com\/blog\/wp-json\/wp\/v2\/posts\/1950\/revisions\/8427"}],"wp:attachment":[{"href":"https:\/\/www.abrima.com\/blog\/wp-json\/wp\/v2\/media?parent=1950"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.abrima.com\/blog\/wp-json\/wp\/v2\/categories?post=1950"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.abrima.com\/blog\/wp-json\/wp\/v2\/tags?post=1950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}