Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand. Home » Blog » Convert Time to Decimal Number in Excel (Hours, Minutes, Seconds). Now you can use any of the three methods covered above (using arithmetic multiplication, using HOUR/MINUTE/SECOND formula, or using the CONVERT formula) to convert the time to decimal. To change the cell format use keyboard shortcut Ctrl+1 to bring up the Format Cells dialog box, select the Number tab, click Time, then select the h:ss format as shown below. I can’t pass the results to an underlying worksheet and have Excel convert them, nor can I use Excel to do the calculations in the first place. B1=End Time 16:00 In the event that you have time in decimals and you want to convert the decimal to minutes, then you can multiply it by 1440, which is the number of minutes in a day. Convert time to decimal hours/minutes/seconds with formulas. Right click at the selected range and click Format Cells from context menu. 1. See screenshot: 2. You can also use these same methods covered above to convert time to minutes and seconds. Popular Articles: 50 Excel Shortcut to Increase Your Productivity. You also can use this formula to convert time to hours =HOUR(A1)+MINUTE(A1)/60+SECOND(A1)/3600. See screenshots: After selecting the converting option, a dialog popped out to remind you how many cells have been converted. Hang tight for 30 secs while we redirect you. A full day (24 hours) is stored as 1 in Excel. Where we have multiplied, we shall divide, and where we have divided, we shall multiple. See screenshot: If you want to convert time in format hh:mm:ss to decimal hours, minutes or seconds, the Convert Time utility of Kutools for Excel to quickly solve this job. Free upgrade and support for 2 years. Thanks. Assume 8:50 AM is in cell A2 and 3:28 PM is in cell B2. 1. See screenshots: Now the data is converted and saved in another location. The 2:31 is multiplied by 24 hours/day and 60 minutes/hour to convert to 151 minutes. Here are three simple steps to convert decimal to time. Become an Excel expert in 3 minutes. How to use the SUMIF Function in Excel Times in Excel are factional values of 24 hours. I need help badly. Here are some simple formulas which can help you to quickly convert decimal hours or decimal minutes to hh:mm:ss. That’s always a hard one. How this formula work. Again, definitely the easiest way to convert time to minutes is by using the convert formula. In a day, there are 1440 minutes (24*60). There are multiple ways to convert time to decimal in Excel: In the sections that follow, I will show you examples of how to convert Excel time to decimal values using these methods. Select the data range and click Kutools > Content > Convert Time > Convert Time. Let’s quickly have a look at those examples as well. Note: In case you get the hour value that has the decimals (such as 18.53), make you sure you have formatted it to show the decimals as well. Hello, suraj V, this tutorial https://www.extendoffice.com/documents/excel/3081-excel-add-hours-minutes-seconds-to-date.html may help you. I sent him a spreadsheet with all the calculations that you have to go through to make this work. In some cases, you may record time as decimal hours or minutes such as this 31.23, how can you convert this decimal hours or decimal minutes to standard time format hh:mm:ss as below screenshot shown. See screenshot: 3. Eg. If  you have a lot of conversions then one column for the decimal values and another column for a formula dividing by 24 will suffice. The example above shows three columns for illustrative purposes and is not very practical. Understanding this, you can convert a time to hours by multiplying the time by 24: Convert Time to Minutes.