To convert time to seconds, multiply the time time by 86400, which is the number of seconds in a day (24*60*60 ). To convert the time in cell B3 to decimal hours in cell C3, please use below formula: =B3*24. This is a pretty standard way to convert time to hours. When you use (24*60) which is the total number of minutes in a day, it returns and number with decimals. Step 1: Enter the Data. The following example shows how to use this formula in practice. This will open the Format Cells dialog box. The TIME Function is categorized under Excel DATE/TIME functions. DATE function. After that, Write the following formula in D5: =C5*24 Then, Press the Enter button //-->, Convert Conventional Hours into a Decimal #. In this number integer part, represents hours, and decimals of minutes. Understanding this, you can convert a time to hours by multiplying the time by 24: =B3*24 Format as Number When you multiply time by 24, Excel may format the result as time (ex. Understanding this, you can convert a time to hours by multiplying the time by 24: Convert Time to Minutes. And in the Excel time system, this would be a value of 2/24 or 0.08333. Fortunately this is easy to do and the following step-by-step example shows how to do so. In such scenarios, TIME can be used to convert a text string into a decimal format that represents the time. It has the following syntax: =TIMEVALUE (time_text) The TEXTVALUE Function - worked example To use this function, you need a cell that contains a text value which has been entered to look like a time. TIME helps us to create a time with individual hour, minute, and second components. In the example shown, the formula in F5 is: = TIME ( LEFT (E5,2), MID (E5,3,2), RIGHT (E5,2)) Which parses a 6-character time string in hhmmss format into a valid Excel time. And, in the Type menu, select h:mm. Convert time difference to hours. =TEXT (C5/24," [h] ""hours,"" m ""minutes""") Formula Breakdown Convert Time to Minutes or Hours Convert Time to Hours. google_ad_client = "pub-7001685384574168"; Converting decimal time to hours using the CONVERT function. The TIMEVALUE function is used to convert a text value into a time value. google_ad_height = 250; h:mm): See screenshot: =(B2-A2)*24. Excel stores time as a decimal value where each 1/24th represents one hour of a day. While doing financial analysis, we might wish to put a time stamp on a report. Generic formula = A1 * 24 Explanation In the Excel time system, one 24-hour day is equal to 1. In my set-up, calculating with dates and times automatically displays a date/time format for the result With your example the result was "6:00 AM". Type your hours and minutes in an hh:mm format. The second way is using the excel CONVERT function, an excel function to convert from and to various units of measurement. Change format to Custom and type [m] to see 320. RELATED: How to Use the Accounting Number Format in Microsoft Excel This function is useful in formulas where you need to calculate an age. Calculates the number of days, months, or years between two dates. In the example shown, the formula in F5 is: = MOD (C5 + (E5 / 24),1) This formula returns a number that Excel recognizes as 2:00 AM. 1. Let's say you want to find out how many hours there are in 5.5 days, or how many days there are in 3.45 years, or how precisely how many months will pass between a beginning date and an ending date. Click on "Format Cells". Click Home tab, and go to the Number Format drop-down list to choose General or Number to display the result as a number. To convert time to minutes, multiply the time by 1440, which is the number of minutes in a day (24*60). In other words, time in Excel has fractional values. First, let's enter the following dataset in Excel that shows the time (in minutes) that it took for various athletes to finish some task: Step 2: Divide Minutes . You can use the following formula to convert a time duration to seconds in Excel: =VALUE (B2*24*3600) This particular formula converts the time duration in cell B2 to seconds. Perform Arithmetic Calculation to Convert Time to Hours In this portion of this article, I am going to describe how to Convert Time to Hours by performing Arithmetic Calculation step by step. To convert time to a number of hours, multiply the time by 24, which is the number of hours in a day. Sorted by: 1. Formatting as a number made it "8.25". So this allows us to convert the time in Excel to decimals. Click on "Format Cells" I.e.