{"id":8668,"date":"2018-06-15T16:00:09","date_gmt":"2018-06-15T14:00:09","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=8668"},"modified":"2018-06-15T16:00:09","modified_gmt":"2018-06-15T14:00:09","slug":"formula-de-tempo-no-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-formulas\/time-formula-in-google-sheets\/","title":{"rendered":"Como usar a f\u00f3rmula TIME no Planilhas Google"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

The\u00a0<\/span>TIME<\/a>\u00a0<\/span>formula in Google Sheets accepts a given time through the hour, minute, and second component values, and returns a time type value.<\/p>\n

Syntax<\/h3>\n

TIME(hour, minute, second)<\/strong><\/p>\n

The\u00a0<\/span>hour<\/strong>,\u00a0<\/span>minute<\/strong>\u00a0<\/span>and\u00a0<\/span>second<\/strong>\u00a0<\/span>are self-explanatory parameters that accept corresponding components of a time. These can be direct numeric values or references to cells that have corresponding numeric values. Also, the respective parameter inputs can be outputs that the formulas such as\u00a0<\/span>HOUR<\/a>,\u00a0<\/span>MINUTE<\/a>\u00a0<\/span>and\u00a0<\/span>SECOND<\/a>\u00a0returns.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Usage: TIME formula in Google Sheets<\/h3>\n

Using this formula is a pretty straightforward process. Let us understand the formula using a few examples.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/TIME-formula-in-Google-Sheets-1.png” alt=”TIME formula in Google Sheets 1″ title_text=”TIME formula in Google Sheets 1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Please notice that all the outputs are \u2018time\u2019 formatted, except the third, which \u2018number\u2019 formatted. This is done deliberately, just to illustrate that a time is a number after all. You may recall that a date is a natural number. However, the time is a decimal number.<\/p>\n

The first example accepts\u00a0direct numbers and returns a corresponding time value.\u00a0The parameters for the second and third examples are references to cells that contain hour, minute and second values. Accordingly, we get the output times.<\/p>\n

The final example shows that the TIME formula in Google Sheets can also accept other appropriate formulas for its parameters. And, it returns yet another time as expected.<\/p>\n

Note<\/h4>\n

What happens if we try and input a value that is not valid in reality? Please have a look at the following image.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/TIME-formula-in-Google-Sheets-2.png” alt=”TIME formula in Google Sheets 2″ title_text=”TIME formula in Google Sheets 2″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

In each of these examples, you will notice we have tried to input invalid hour, minute and second values respectively. Yet, we don\u2019t see any errors in the output values. That is because the TIME formula is capable of appropriately offsetting the excess values from the hour, minute or second parameters.<\/p>\n

For instance, in the first example, 26 hours correspond to 1 day + 2 hours, wherein it disregards the day component and considers only 2 hours for its\u00a0<\/span>hour<\/strong>component.\u00a0Similarly, 81 minutes in the second example is equivalent to 1 hour + 21 minutes. So, it adds the extra 1 hour is to the\u00a0<\/span>hour<\/strong>\u00a0<\/span>component and considers 21 minutes for the\u00a0<\/span>minute<\/strong>\u00a0<\/span>component. On the similar lines, 115 seconds in the third example is equal to 1 minute + 55 seconds. Accordingly, the TIME formula increments the\u00a0minute<\/strong>\u00a0<\/span>component by 1 minute, while it picks up 55 seconds for the\u00a0second<\/strong>\u00a0<\/span>component.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

TIME formula<\/h3>\n

And there you go! Use the TIME formula in Google Sheets to return a time type value.<\/p>\n

If you\u2019d like to learn more about the various formulas of Google Sheets, why not take a look at our blog post on How location and timezone can affect your Google Sheets.<\/span><\/a><\/p>\n

Alternatively, check out related blog posts below!<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

The\u00a0TIME\u00a0formula in Google Sheets accepts a given time through the hour, minute, and second component values, and returns a time type value. Syntax TIME(hour, minute, second) The\u00a0hour,\u00a0minute\u00a0and\u00a0second\u00a0are self-explanatory parameters that accept corresponding components of a time. These can be direct numeric values or references to cells that have corresponding numeric values. Also, the respective parameter […]<\/p>\n","protected":false},"author":40,"featured_media":8669,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"The TIME<\/a> formula in Google Sheets accepts a given time through the hour, minute, and second component values, and returns a time type value.\n

Syntax<\/h3>\nTIME(hour, minute, second)<\/strong>\n\nThe hour<\/strong>, minute<\/strong> and second<\/strong> are self-explanatory parameters that accept corresponding components of a time. These can be direct numeric values or references to cells that have corresponding numeric values. Also, the respective parameter inputs can be outputs that the formulas such as HOUR<\/a>, MINUTE<\/a> and SECOND<\/a>\u00a0returns.\n

Usage: TIME formula in Google Sheets<\/h3>\nUsing this formula is a pretty straightforward process. Let us understand the formula using a few examples.\n\n\"TIME\n\nPlease notice that all the outputs are \u2018time\u2019 formatted, except the third, which \u2018number\u2019 formatted. This is done deliberately, just to illustrate that a time is a number after all. You may recall that a date is a natural number. However, the time is a decimal number.\n\nThe first example accepts\u00a0direct numbers and returns a corresponding time value.\u00a0The parameters for the second and third examples are references to cells that contain hour, minute and second values. Accordingly, we get the output times.\n\nThe final example shows that the TIME formula in Google Sheets can also accept other appropriate formulas for its parameters. And, it returns yet another time as expected.\n

Note<\/h4>\nWhat happens if we try and input a value that is not valid in reality? Please have a look at the following image.\n\n\"TIME\n\nIn each of these examples, you will notice we have tried to input invalid hour, minute and second values respectively. Yet, we don't see any errors in the output values. That is because the TIME formula is capable of appropriately offsetting the excess values from the hour, minute or second parameters.\n\nFor instance, in the first example, 26 hours correspond to 1 day + 2 hours, wherein it disregards the day component and considers only 2 hours for its hour<\/strong> component.\u00a0Similarly, 81 minutes in the second example is equivalent to 1 hour + 21 minutes. So, it adds the extra 1 hour is to the hour<\/strong> component and considers 21 minutes for the minute<\/strong> component. On the similar lines, 115 seconds in the third example is equal to 1 minute + 55 seconds. Accordingly, the TIME formula increments the\u00a0minute<\/strong> component by 1 minute, while it picks up 55 seconds for the\u00a0second<\/strong> component.","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8668","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/8668","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=8668"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/8668\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/8669"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=8668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=8668"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=8668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}