{"id":502812,"date":"2022-10-21T22:00:37","date_gmt":"2022-10-21T19:00:37","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-add-or-subtract-time-in-google-sheets\/"},"modified":"2022-10-21T22:00:37","modified_gmt":"2022-10-21T19:00:37","slug":"how-to-add-or-subtract-time-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-add-or-subtract-time-in-google-sheets\/","title":{"rendered":"#How to Add or Subtract Time in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a3be861b6ea1\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a3be861b6ea1\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-or-subtract-time-in-google-sheets\/#%E2%80%9CHow_to_Add_or_Subtract_Time_in_Google_Sheets%E2%80%9D\" >&#8220;How to Add or Subtract Time in Google Sheets&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-or-subtract-time-in-google-sheets\/#Add_Time_in_Google_Sheets\" >Add Time in Google Sheets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-or-subtract-time-in-google-sheets\/#Subtract_Time_in_Google_Sheets\" >Subtract Time in Google Sheets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-or-subtract-time-in-google-sheets\/#Find_the_Difference_Between_Two_Specified_Times\" >Find the Difference Between Two Specified Times<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Add_or_Subtract_Time_in_Google_Sheets%E2%80%9D\"><\/span>&#8220;How to Add or Subtract Time in Google Sheets&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-741481\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/Google-Sheets-Logo-Lede.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"The Google Sheets logo\" width=\"1200\" height=\"675\"\/><\/p>\n<p>Format the cells containing times as either a specific time or duration with Format &gt; Number &gt; Time or Duration. You can then use standard + and &#8211; operators to add and subtract the times in calculations.<\/p>\n<p>Want to add, subtract, or find the difference (duration) between two times? If so, Google Sheets makes it super easy to do just that, no function required. We\u2019ll show you how.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Add_Time_in_Google_Sheets\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_0\">Add Time in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To add hours, minutes, or seconds to your specified time on Google Sheets, use the standard \u201c+\u201d (plus) operator.<\/p>\n<p>Start by opening your web browser, launching <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/docs.google.com\/spreadsheets\/u\/0\/\">Google Sheets<\/a>, and accessing your spreadsheet. We\u2019ll use the following sheet as an example:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833720\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/1-add-time-google-sheet.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Time addition sample Google Sheet\" width=\"650\" height=\"377\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In this spreadsheet, we\u2019ll use the following cells:<\/p>\n<ul>\n<li><strong>B2:<\/strong> This cell contains the start time. We\u2019ll add our time to this time.<\/li>\n<li><strong>C2:<\/strong> This is where we\u2019ll specify the time to add.<\/li>\n<li><strong>D2:<\/strong> This will display the resulting time.<\/li>\n<\/ul>\n<p>Since both B2 and D2 will display actual times, we\u2019ll format them to use the time format. To do that, we\u2019ll select those cells and choose Format &gt; Number &gt; Time from the menu bar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833751\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/2-add-time-cell-format.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Time format options inside Google Sheets\" width=\"650\" height=\"431\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>We\u2019ll then select the C2 cell and choose Format &gt; Number &gt; Duration. This is because this cell will display a time period and not the time itself.<\/p>\n<p>We\u2019ll add 5 hours, 54 minutes, and 28 seconds to the specified time. To do that, we\u2019ll click the C2 cell and enter <code>5:54:28<\/code>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833721\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/3-specify-add-time.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Adding time in Google Sheets\" width=\"650\" height=\"435\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the D2 cell, where we want to display the resulting time, we\u2019ll enter the following formula and press Enter.<\/p>\n<pre>=B2+C2&#13;\n<\/pre>\n<p>This formula adds the time period in the C2 cell to the time in the B2 cell. You\u2019ll see the resulting time in the D2 cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833722\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/4-added-time.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Resulting time in Google Sheets\" width=\"650\" height=\"412\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And you\u2019re all set.<\/p>\n<p>If you\u2019d like to include dates in your calculation, then select your cells and choose Format &gt; Number &gt; Date Time from the menu bar.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Subtract_Time_in_Google_Sheets\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_1\">Subtract Time in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To subtract time in Google Sheets, make use of the standard \u201c-\u201d (minus) operator.<\/p>\n<p>Start by launching your spreadsheet on <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/docs.google.com\/spreadsheets\/u\/0\/\">Google Sheets<\/a>. We\u2019ll use the following sheet as an example:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833723\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/5-subtract-time-google-sheet.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Time subtraction sample Google Sheet\" width=\"650\" height=\"386\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In this spreadsheet, we\u2019ll use these cells:<\/p>\n<ul>\n<li><strong>B2:<\/strong> This cell has the time from which you\u2019ll be subtracting a time period.<\/li>\n<li><strong>C2:<\/strong> This is where you\u2019ll define the time period to subtract.<\/li>\n<li><strong>D2:<\/strong> This cell will show the resulting time.<\/li>\n<\/ul>\n<p>We\u2019ll select the B2 and D2 cells and make them use the time formatting by choosing Format &gt; Number &gt; Time from the menu bar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833752\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/6-subtract-time-cell-format.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Time formatting options in Google Sheets\" width=\"650\" height=\"424\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>We\u2019ll choose Format &gt; Number &gt; Duration for the C2 cell. In the C2 cell, we\u2019ll specify the time period to subtract from the B2 cell. As an example, we\u2019ll use 8 hours by entering <code>8:00:00<\/code> .<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833724\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/7-specify-subtract-time.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Time to subtract in Google Sheets \" width=\"650\" height=\"409\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the D2 cell, we\u2019ll enter the following formula and press Enter:<\/p>\n<pre>=B2-C2<\/pre>\n<p>The resulting time will appear in the D2 cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833725\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/8-subtracted-time.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Resulting time in Google Sheets\" width=\"650\" height=\"394\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And that\u2019s the resulting time after subtracting your specified time period from the source time.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Find_the_Difference_Between_Two_Specified_Times\"><\/span>Find the Difference Between Two Specified Times<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To find the difference between two times (for example, how many hours are between 9 a.m. and 6 p.m.), use the following method.<\/p>\n<p>We\u2019ll use the below spreadsheet as an example:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833726\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/9-time-difference-google-sheet.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Sample Google Sheet to find the time difference\" width=\"650\" height=\"342\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In this spreadsheet, we\u2019ve used the following cells:<\/p>\n<ul>\n<li><strong>B2:<\/strong> This cell shows the start time.<\/li>\n<li><strong>C2:<\/strong> This cell shows the end time.<\/li>\n<li><strong>D2:<\/strong> This cell will display the actual time difference between the start and end times.<\/li>\n<\/ul>\n<p>Since the B2 and the C2 cells will display actual times, we\u2019ll time format them by choosing Format &gt; Number &gt; Time from the menu bar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833727\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/10-format-time-difference-cells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Time format options in Google Sheets\" width=\"650\" height=\"488\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For the D2 cell, we\u2019ll choose Format &gt; Number &gt; Duration as it\u2019ll display the time duration between the two specified times.<\/p>\n<p>As you may have already guessed, we\u2019ll find the time difference between 9:00:00 a.m. and 5:32:49 p.m. To do that, in the D2 cell, we\u2019ll type the following formula and press Enter:<\/p>\n<pre>=C2-B2<\/pre>\n<p>In the D2 cell, you\u2019ll see the time difference.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833728\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/11-time-difference-result.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"The difference between the specified times\" width=\"650\" height=\"397\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you\u2019d like to extract hours from your result, then enter <code>=HOUR(D2)<\/code> in a cell. To extract minutes and seconds, use <code>=MINUTE(D2)<\/code> and <code>=SECOND(D2)<\/code> in any cell, respectively.<\/p>\n<p>That\u2019s how you add, subtract, and find the time difference in your Google Sheets. Easy!<\/p>\n<hr\/>\n<p>Want to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/447556\/count-the-days-between-two-dates-in-google-sheets\/\">count the days between two dates in Google Sheets? If so, it\u2019s easy to do that too.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Count the Days Between Two Dates in Google Sheets<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/833717\/how-to-add-or-subtract-time-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Add or Subtract Time in Google Sheets&#8221; Format the cells containing times as either a specific time or duration with Format &gt; Number &gt; Time or Duration. You can then use standard + and &#8211; operators to add and subtract the times in calculations. Want to add, subtract, or find the difference (duration)&#8230;<\/p>\n","protected":false},"author":1,"featured_media":502813,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/Google-Sheets-Logo-Lede.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-502812","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/502812","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=502812"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/502812\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/502813"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=502812"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=502812"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=502812"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}