#TIME TO DECIMAL TIME CONVERTER EXCEL HOW TO#
#TIME TO DECIMAL TIME CONVERTER EXCEL SERIAL#
#TIME TO DECIMAL TIME CONVERTER EXCEL TRIAL#

In the same way, 12:00 PM has the value ½ or 0.5, which corresponds to one-half of one day. Notice that the value for 6:00 AM is ¼ or 0.25, since it corresponds to one-fourth of one day. Sample data showing how times are stored in Excel The reference time is 12 midnight, which has the value zero “0”.įigure 3. Hence, one hour is stored as a fraction of one day or 1/24.īelow table shows some examples of how times are stored in fraction and in decimal form. Our formula looks like this:ĭecimal Minutes = Time x 1440 How the formula worksĮxcel uniquely stores times as numbers. Sample data to convert time to decimal minutes Convert Excel time to decimal minutesĮxcel time can be easily converted to decimal minutes by multiplying the time by 1440. It is important to set the format for column C to General or Number so that the decimal minutes is correctly presented.įigure 2. The results will be recorded in column C. We want to convert the time in column B into decimal minutes. Our data consists of two columns: Time (column B) and Result (column C). Final result: Convert Excel time to decimal minutes Setting up our Data This step by step tutorial will assist all levels of Excel users in converting Excel time to decimal minutes.įigure 1.

#TIME TO DECIMAL TIME CONVERTER EXCEL SERIAL#

You’ll have to rename the column back to Minutes, but you’ll have that formula now applied to every row of your spreadsheet for that column.Excel has a unique way of storing time through serial numbers, making it possible to perform mathematical operations and conversions to values of time.Select the entire column (column C in my example) by selecting the column header.

Copy (Ctrl+C) the result in the first cell with the formula (C3 in my example).

To apply this formula to the entire column:

When you release the mouse, all those cells you dragged this formula over will be converted to minutes and seconds.

#TIME TO DECIMAL TIME CONVERTER EXCEL HOW TO#

(See below for how to apply it to ALL cells in the column.) Click in the C3 cell and ‘grab’ the bottom right handle of the cell marker (it turns to a + sign when you’ve grabbed it correctly) and drag it down the other cells in column C.Type =B3*1440 in the formula bar, then press Enter to convert the hours and minutes into minutes.In my example, that was C3, which pairs with B3. Put the cursor in the first cell in the new column that pairs with a cell in the hh:mm column.(To format the column, select the column header, right-click on it, select Format Cells, select Number on the Number tab, then change the Decimal Places value to 0. Click OK.) Set the format for the cells in this new column to Number with no decimal places - this formatting is critical for the formula to work.Insert a new column (C) and called it Minutes.(To format the column, select the column header, right-click on it, select Format Cells, select Custom on the Number tab, then select h:mm from the list of types. Set the format for this column to Custom > h:mm.(Yes, those non-stop flights to/from Sydney to Dallas Fort Worth are killers!) Enter elapsed times in hours and minutes (using the format hh:mm) in Column B.This is where I got caught - I didn’t have the correct formatting applied to the cells. To convert hours and minutes to minutes, you have to multiply the hh:mm value by 1440 (which is 24 multiplied by 60 ), AND make sure you set the formatting correctly for the both the hh:mm cells and the resulting minute cells.

#TIME TO DECIMAL TIME CONVERTER EXCEL TRIAL#

But I had to do quite a bit of trial and error and Googling to get it to work. Converting hours and minutes (hh:mm) to minutes in an Excel spreadsheet is actually quite simple, once you know what to do.

Time to decimal time converter excel