{"id":485521,"date":"2022-08-17T20:00:05","date_gmt":"2022-08-17T17:00:05","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-convert-time-to-decimals-in-microsoft-excel\/"},"modified":"2022-08-17T20:00:05","modified_gmt":"2022-08-17T17:00:05","slug":"how-to-convert-time-to-decimals-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-convert-time-to-decimals-in-microsoft-excel\/","title":{"rendered":"#How to Convert Time to Decimals in Microsoft Excel"},"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-6a4169705b852\" 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-6a4169705b852\" 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-convert-time-to-decimals-in-microsoft-excel\/#%E2%80%9CHow_to_Convert_Time_to_Decimals_in_Microsoft_Excel%E2%80%9D\" >&#8220;How to Convert Time to Decimals in Microsoft Excel&#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-convert-time-to-decimals-in-microsoft-excel\/#Use_the_Time_and_Decimal_Formats\" >Use the Time and Decimal Formats<\/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-convert-time-to-decimals-in-microsoft-excel\/#Convert_Using_Multiplication\" >Convert Using Multiplication<\/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-convert-time-to-decimals-in-microsoft-excel\/#Convert_Using_the_CONVERT_Function\" >Convert Using the CONVERT Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-convert-time-to-decimals-in-microsoft-excel\/#Convert_Using_Time_Function_Formulas\" >Convert Using Time Function Formulas<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Convert_Time_to_Decimals_in_Microsoft_Excel%E2%80%9D\"><\/span>&#8220;How to Convert Time to Decimals in Microsoft Excel&#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-757715\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" width=\"1200\" height=\"675\"\/><\/p>\n<p>While Excel offers many features and functions for working with times, you may want your times formatted as decimals instead. You might need them for use in other formulas, for a timesheet, or for your own preference.<\/p>\n<p>Here are a few ways to convert time to decimals in Excel. You can use whichever method you\u2019re most comfortable with or works best for you.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_the_Time_and_Decimal_Formats\"><\/span>Use the Time and Decimal Formats<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Before you convert the times and decimals in your sheet, make sure that the cells are formatted as such.<\/p>\n<p><strong>RELATED:<\/strong> <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/768046\/how-to-use-the-accounting-number-format-in-microsoft-excel\/\"><strong><em>How to Use the Accounting Number Format in Microsoft Excel<\/em><\/strong><\/p>\n<p>For time, you can do this by selecting the cell and choosing \u201cTime\u201d in the Number drop-down box on the Home tab. \u00a0If you plan to convert hours, minutes, <i>and<\/i> seconds, it\u2019s best to use the Format Cells feature. Select the cell or range, right-click, and pick \u201cFormat Cells.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-818594\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/FormatCells-ExcelConvertTimeDecimal.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Format Cells in the shortcut menu\" width=\"272\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Choose the Number tab and pick \u201cTime\u201d on the left. Then, pick the hours:minutes:seconds option on the right as shown below and click \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-818583 size-full\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/FormatCellsTime-ExcelConvertTimeDecimal.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Format Cells as Time in Excel\" width=\"539\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For decimals, format your result cells as numbers also using the Format Cells feature. Right-click the cell(s) and pick \u201cFormat Cells.\u201d<\/p>\n<p>Choose the Number tab and pick \u201cNumber\u201d on the left. Set the number of decimal places to 2 on the right and click \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-818582\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/FormatCellsNumber-ExcelConvertTimeDecimal.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Format Cells as Number in Excel\" width=\"539\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you end up with a whole number as your result, you can use the Increase and Decrease Decimal buttons in the Number section of the Home tab to adjust the <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>earance. This lets you display 624.00 as 624.<\/p>\n<p>You\u2019re then ready to start converting.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Convert_Using_Multiplication\"><\/span>Convert Using Multiplication<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you\u2019re not fond of <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/765624\/basic-excel-functions-everybody-should-know\/\">using functions and building the accompanying formulas in Excel, you can convert time to decimals with simple multiplication.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>12 Basic Excel Functions Everybody Should Know<\/em><\/strong><\/p>\n<p>You\u2019ll multiply the cell containing the time by the number of hours, minutes, or seconds in a day. Here, we have our time in cell A2. To obtain the hours as a decimal, we multiply that value by 24, for 24 hours in a day.<\/p>\n<pre>=A2*24<\/pre>\n<p>To obtain the decimal for minutes and seconds using that same cell value, you would multiply by the number of minutes (1,440) and then the number of seconds (86,400) in a day as follows:<\/p>\n<pre>=A2*1440<\/pre>\n<pre>=A2*86400<\/pre>\n<p>As you can see, we receive the number results for our time conversions.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-818584\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/Multiplication-ExcelConvertTimeDecimal.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Multiplication conversions\" width=\"500\" height=\"150\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Convert_Using_the_CONVERT_Function\"><\/span>Convert Using the CONVERT Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Another option for getting decimals for <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/740488\/how-to-add-or-subtract-times-in-microsoft-excel\/\">times in Excel is with the CONVERT function. This versatile function lets you convert times, measurements, weights, and more.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Add or Subtract Times in Microsoft Excel<\/em><\/strong><\/p>\n<p>The syntax for the function is <code>CONVERT(reference, from, to)<\/code> where you\u2019ll use all three arguments. For the <code>from<\/code> argument, you\u2019ll use \u201cday.\u201d<\/p>\n<p>To convert a time in cell A2 to hours, you would use this formula:<\/p>\n<pre>=CONVERT(A2,\"day\",\"hr\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-818586\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/ConvertFunctionHours-ExcelConvertTimeDecimal.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"CONVERT function formula for hours\" width=\"540\" height=\"150\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also use \u201cd\u201d instead of \u201cday\u201d for the <code>from<\/code> argument.<\/p>\n<p>To convert that same time to minutes and seconds, you would use these formulas:<\/p>\n<pre>=CONVERT(A2,\"day\",\"mn\")<\/pre>\n<pre>=CONVERT(A2,\"day\",\"sec\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-818587\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/ConvertFunctionMinutes-ExcelConvertTimeDecimal.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"CONVERT function formula for minutes\" width=\"540\" height=\"150\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also use \u201cmin\u201d instead of \u201cmn\u201d for minutes and \u201cs\u201d instead of \u201csec\u201d for seconds.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Convert_Using_Time_Function_Formulas\"><\/span>Convert Using Time Function Formulas<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>This last method uses <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/794192\/excel-date-and-time-functions\/\">Excel\u2019s time functions. Although the formulas are much lengthier than those above, it\u2019s still another option you might prefer. Here, you\u2019ll use the HOUR, MINUTE, and SECOND functions with a combination of calculations.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>13 Microsoft Excel Date and Time Functions You Should Know<\/em><\/strong><\/p>\n<p>To convert the time in cell A2 to hours, you would use this formula:<\/p>\n<pre>=HOUR(A2)+MINUTE(A2)\/60+SECOND(A2)\/3600<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-818588\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/TimeFunctionHours-ExcelConvertTimeDecimal.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Time function formula for hours\" width=\"650\" height=\"139\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Each function references the cell A2 and the results are added together. The MINUTE portion is divided by 60 for 60 minutes in an hour and the SECOND portion is divided by 3,600 for 3,600 seconds in an hour.<\/p>\n<p>To convert the same time to minutes, you would use this formula:<\/p>\n<pre>=HOUR(A2)*60+MINUTE(A2)+SECOND(A2)\/60<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-818589\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/TimeFunctionMinutes-ExcelConvertTimeDecimal.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Time function formula for minutes\" width=\"650\" height=\"140\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Similar to the formula for hours, you add the result of the functions together. The HOUR portion is multiplied by 60 for 60 minutes in an hour and the SECOND portion is divided by 60 for 60 seconds in a minute.<\/p>\n<p>To convert that time to seconds, you would use this formula:<\/p>\n<pre>=HOUR(A1)*3600+MINUTE(A2)*60+SECOND(A2)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-818590\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/TimeFunctionSeconds-ExcelConvertTimeDecimal.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Time function formula for seconds\" width=\"650\" height=\"140\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>With this formula, the HOUR portion is multiplied by 3,600 for 3,600 seconds in an hour and the MINUTE portion is multiplied by 60 for 60 seconds in a minute.<\/p>\n<p>As you can see, this last method requires more effort, but if you\u2019re familiar with using time functions in Excel, it might be your preferred one.<\/p>\n<p>Converting time to decimals in Excel sounds more difficult than it is. And, when you pick the above method that you like best, you\u2019ll be converting in no <em>time<\/em>.<\/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\/818578\/convert-time-to-decimal-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Convert Time to Decimals in Microsoft Excel&#8221; While Excel offers many features and functions for working with times, you may want your times formatted as decimals instead. You might need them for use in other formulas, for a timesheet, or for your own preference. Here are a few ways to convert time to&#8230;<\/p>\n","protected":false},"author":1,"featured_media":485522,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-485521","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\/485521","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=485521"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/485521\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/485522"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=485521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=485521"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=485521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}