{"id":33276,"date":"2023-12-04T05:02:22","date_gmt":"2023-12-04T04:02:22","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=33276"},"modified":"2024-03-22T16:15:13","modified_gmt":"2024-03-22T15:15:13","slug":"time-to-decimal-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/time-to-decimal-in-excel\/","title":{"rendered":"Convert Time to Decimal in Excel &#8211; Top 3 Methods"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Time-to-Decimal.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-33319\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Time-to-Decimal-1024x576.png\" alt=\"Time to Decimal\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Time-to-Decimal-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Time-to-Decimal-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Time-to-Decimal-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Time-to-Decimal.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><\/a><\/p>\n<p>In <strong>Excel<\/strong>, time is represented in the format <strong>HH:MM:SS, where HH represents hours, MM represents minutes, and SS represents seconds<\/strong>. But, you may need to <strong>convert time to decimal<\/strong> to perform <strong>complex calculations and analysis<\/strong>. This process is particularly useful in scenarios where you need to<strong> perform mathematical operations on time durations<\/strong>.<\/p>\n<p>In this article, we will explore <strong>three methods<\/strong> mentioned to convert time to decimal <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-excel-time-to-decimal\/\" target=\"_blank\" rel=\"noopener\">in Excel<\/a> &#8211;<\/p>\n<h4>Download the Excel Workbook below to follow along and understand How to Convert Time to Decimal in Excel \u2013 <a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Convert-Time-to-Decimal.xlsx\" target=\"_blank\" rel=\"noopener\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel\u00a0<\/strong><strong>workbook<\/strong><\/span><span class=\"postTitle px-3\">Convert-Time-to-Decimal.xlsx<\/span><\/a><\/h4>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/time-to-decimal-in-excel\/#Method_1_%E2%80%93_Multiplication\" title=\"Method 1 \u2013 Multiplication\">Method 1 \u2013 Multiplication<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/time-to-decimal-in-excel\/#Method_2_%E2%80%93_HOUR_MINUTE_and_SECOND\" title=\"Method 2 \u2013 HOUR, MINUTE and SECOND\">Method 2 \u2013 HOUR, MINUTE and SECOND<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/time-to-decimal-in-excel\/#Method_3_%E2%80%93_CONVERT\" title=\"Method 3 \u2013 CONVERT\">Method 3 \u2013 CONVERT<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/time-to-decimal-in-excel\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Method_1_%E2%80%93_Multiplication\"><\/span><span id=\"2\" style=\"color: #ff0000\">Method 1 \u2013 Multiplication<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Excel stores time as numbers and a 24-hour day is equal to 1. To convert time to a number of hours, <strong>multiply<\/strong> the time by 24.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Time-to-Decimal-100.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33378\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Time-to-Decimal-100.png\" alt=\"Time to Decimal\" width=\"537\" height=\"672\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Time-to-Decimal-100.png 537w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Time-to-Decimal-100-240x300.png 240w\" sizes=\"(max-width: 537px) 100vw, 537px\" title=\"\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_2_%E2%80%93_HOUR_MINUTE_and_SECOND\"><\/span><span id=\"2\" style=\"color: #ff0000\">Method 2 \u2013 HOUR, MINUTE and SECOND<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>One straightforward way to convert time to decimal in Excel is by utilizing the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/calculate-elapsed-time-in-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>HOUR, MINUTE, and SECOND<\/strong><\/a> functions. These functions are used to<strong> extract the hour, minute, and second components<\/strong> from a given time, respectively.<\/p>\n<p>Suppose you have time displayed in the hh:mm:ss format in column A and you want to convert it into decimal format.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33282\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-1.png\" alt=\"Time to decimal\" width=\"325\" height=\"635\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-1.png 325w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-1-154x300.png 154w\" sizes=\"(max-width: 325px) 100vw, 325px\" title=\"\"><\/a><\/p>\n<p>The general syntax to convert time to decimal is &#8211;<\/p>\n<p><strong>=HOUR(serial_number)+MINUTE(serial_number)\/60+SECOND(serial_number)\/3600<\/strong><\/p>\n<ul>\n<li><strong>HOUR(serial_number)<\/strong> &#8211; This extracts the hour component from the time value.<\/li>\n<li><strong>MINUTE(serial_number)\/60<\/strong> &#8211; This extracts the minute component from the time value, and divides it by 60(the number of minutes in an hour) to convert it to hours.<\/li>\n<li><strong>SECOND(serial_number)\/3600<\/strong> &#8211; This extracts the second component from the time value and divides it by 3600(the number of seconds in an hour) to convert it to hours.<\/li>\n<\/ul>\n<p>By combining these three parts, the entire <a class=\"wpil_keyword_link\" title=\"formula\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">formula<\/a> calculates the decimal representation of a given time value. Follow the steps below to achieve this result &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span><\/strong> Enter the hour function.<\/p>\n<p><strong>=HOUR<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33283\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-2.png\" alt=\"Time to decimal\" width=\"563\" height=\"669\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-2.png 563w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-2-252x300.png 252w\" sizes=\"(max-width: 563px) 100vw, 563px\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span><\/strong> Select the cell containing the time. Here, it is A2.<\/p>\n<p><strong>=HOUR(A2)<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33284\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-3.png\" alt=\"Time to decimal\" width=\"557\" height=\"672\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-3.png 557w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-3-249x300.png 249w\" sizes=\"(max-width: 557px) 100vw, 557px\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3:<\/span><\/strong> Enter the addition symbol (+).<\/p>\n<p><strong>=HOUR(A2)+<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-4.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33285\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-4.png\" alt=\"Time to decimal\" width=\"554\" height=\"669\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-4.png 554w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-4-248x300.png 248w\" sizes=\"(max-width: 554px) 100vw, 554px\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 4:<\/span><\/strong> Enter the minute function.<\/p>\n<p><strong>=HOUR(A2)+MINUTE<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-5.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33286\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-5.png\" alt=\"Time to decimal\" width=\"557\" height=\"669\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-5.png 557w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-5-250x300.png 250w\" sizes=\"(max-width: 557px) 100vw, 557px\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 5:<\/span><\/strong> Select the cell containing the time and divide the time by 60 to convert the minute component to an hour.<\/p>\n<p><strong>=HOUR(A2)+MINUTE(A2)\/60<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-6.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33287 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-6-e1701071109387.png\" alt=\"Time to decimal\" width=\"705\" height=\"691\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-6-e1701071109387.png 705w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-6-e1701071109387-300x294.png 300w\" sizes=\"(max-width: 705px) 100vw, 705px\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 6:<\/span><\/strong> Enter the addition symbol (+).<\/p>\n<p><strong>=HOUR(A2)+MINUTE(A2)\/60+<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-7.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33288\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-7.png\" alt=\"Time to decimal\" width=\"633\" height=\"667\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-7.png 633w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-7-285x300.png 285w\" sizes=\"(max-width: 633px) 100vw, 633px\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 7:<\/span><\/strong> Enter the second function.<\/p>\n<p><strong>=HOUR(A2)+MINUTE(A2)\/60+SECOND<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-8.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33289\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-8.png\" alt=\"Time to decimal\" width=\"633\" height=\"668\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-8.png 633w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-8-284x300.png 284w\" sizes=\"(max-width: 633px) 100vw, 633px\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 8:<\/span><\/strong> Select the cell containing the time and divide the time by 3600 to convert the second component to an hour.<\/p>\n<p><strong>=HOUR(A2)+MINUTE(A2)\/60+SECOND(A2)\/3600<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33291\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-10.png\" alt=\"Time to decimal\" width=\"717\" height=\"666\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-10.png 717w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-10-300x279.png 300w\" sizes=\"(max-width: 717px) 100vw, 717px\" title=\"\"><\/a><\/p>\n<p>The time from the hh:mm:ss format can be converted into decimal format using this method.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-11.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33292\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-11.png\" alt=\"Time to decimal\" width=\"700\" height=\"669\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-11.png 700w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-11-300x287.png 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" title=\"\"><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-date-and-time-functions\/\" target=\"_blank\" rel=\"noopener\"><strong>Click here<\/strong><\/a> to learn more about time-related functions in Excel.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_3_%E2%80%93_CONVERT\"><\/span><span id=\"3\" style=\"color: #ff0000\">Method 3 \u2013 CONVERT<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>This function is exclusively available for <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/office-365\/\" target=\"_blank\" rel=\"noopener\"><strong>Excel 365<\/strong><\/a> users. It can be used to convert a number from one measurement system to another. The syntax is &#8211;<\/p>\n<p><b class=\"ocpLegacyBold\">CONVERT<\/b>(<b class=\"ocpLegacyBold\">number<\/b>,<b class=\"ocpLegacyBold\">from_unit<\/b>,<b class=\"ocpLegacyBold\">to_unit<\/b>)<\/p>\n<ul>\n<li><b class=\"ocpRunInHead\">Number<\/b> &#8211; It is the reference value.<\/li>\n<li><b class=\"ocpRunInHead\">From_unit<\/b> &#8211; It is the units of the original value.<\/li>\n<li><b class=\"ocpRunInHead\">To_unit &#8211; <\/b>It is the units for the result.<\/li>\n<\/ul>\n<p>Follow the steps below to achieve this result &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span><\/strong> Enter the CONVERT function.<\/p>\n<p><strong>=CONVERT<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-12.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33293\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-12.png\" alt=\"Time to decimal\" width=\"466\" height=\"667\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-12.png 466w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-12-210x300.png 210w\" sizes=\"(max-width: 466px) 100vw, 466px\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span><\/strong> Enter the first argument i.e. number. Here, it is the cell containing time in hh:mm:ss format (A2).<\/p>\n<p><strong>=CONVERT(A2<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-13.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33294\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-13.png\" alt=\"Time to decimal\" width=\"457\" height=\"669\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-13.png 457w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-13-205x300.png 205w\" sizes=\"(max-width: 457px) 100vw, 457px\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3:<\/span><\/strong> Enter the second argument i.e. from_unit. Here, it is &#8220;day&#8221;.<\/p>\n<p><strong>=CONVERT(A2,&#8221;day&#8221;<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-14.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33295\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-14.png\" alt=\"Time to decimal\" width=\"623\" height=\"670\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-14.png 623w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-14-279x300.png 279w\" sizes=\"(max-width: 623px) 100vw, 623px\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 4:<\/span><\/strong> Enter the third argument i.e. to_unit. Here, it is &#8220;hr&#8221;.<\/p>\n<p><strong>=CONVERT(A2,&#8221;day&#8221;,&#8221;hr&#8221;)<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-15.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33296\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-15.png\" alt=\"Time to decimal\" width=\"548\" height=\"667\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-15.png 548w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-15-246x300.png 246w\" sizes=\"(max-width: 548px) 100vw, 548px\" title=\"\"><\/a><\/p>\n<p>The time value will easily be converted to decimal format using the CONVERT function.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-16.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33297\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-16.png\" alt=\"Time to decimal\" width=\"544\" height=\"677\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-16.png 544w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Time-to-decimal-16-241x300.png 241w\" sizes=\"(max-width: 544px) 100vw, 544px\" title=\"\"><\/a><\/p>\n<p><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/convert-function-d785bef1-808e-4aac-bdcd-666c810f9af2\" target=\"_blank\" rel=\"nofollow noopener\"><strong>Click here<\/strong><\/a> to learn more about the CONVERT function in Excel.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><strong>Conclusion<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In conclusion, while Excel represents time in the HH:MM:SS format, converting it to decimal becomes crucial for intricate calculations. This article explored three methods \u2013 employing the multiplication operator, utilizing HOUR, MINUTE, and SECOND functions, and leveraging the CONVERT function.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Excel, time is represented in the format HH:MM:SS, where HH represents hours, MM represents minutes, and SS represents seconds. But, you may need to convert time to decimal to perform complex calculations and analysis. This process is particularly useful in scenarios where you need to perform mathematical operations on time durations. In this article, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":33319,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[13,524,526,14],"tags":[1481,1482,1483],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/33276"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=33276"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/33276\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/33319"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=33276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=33276"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=33276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}