Microsoft Excel can show and calculate time based on decimal numbers or hours, minutes and seconds. Decimal clock time ranges from 0 to .99999, which represents 12:00 a.m. to 11:59 p.m. Excel provides easy-to-use formulas to convert between time types. By using the MINUTE function, you can convert any decimal clock time to minutes. The function can be used by typing it directly into a cell or through the function assistant in the formula bar.
- Skill level:
Other People Are Reading
Things you need
- Microsoft Excel
Open an existing Microsoft Excel spreadsheet. At least one cell should have a decimal time value. If a value doesn't exist, type a decimal time value into any open cell. The value should be between 0 and .99999.
Click the cell in which you wish to place the converted time in or any other open cell. You can apply the formula to other cells once the first conversion is in place.
Type "=MINUTE(cell reference)" into the cell. The cell reference is the cell you wish to convert. For example, to convert the decimal time in cell B13 to minutes, the formula would be =MINUTE(B13).
Open the function assistant for help in using the MINUTE function. Press the "fx" button on the formula bar to open the assistant. Select "Date and Time" from the drop down menu. Click "MINUTE" and press "OK." Type in your cell reference or press the button to the right of the text box and select your cell on your spreadsheet.
Apply the cell to other cells by first clicking the cell you applied the formula to. Place your cursor over the small square at the bottom right corner of the cell. When the plus sign appears, drag the cell up or down to apply the formula to a section of empty cells. Hold the mouse button down until you've highlighted all the cells you wish to apply the formula to. The cell reference automatically changes accordingly. For instance, if the original formula uses the cell reference B13, dragging the cell down will cause the cell reference in the bottom cell to change to B14.
Tips and warnings
- Create a column of decimal time values so you can then create the conversion cells beside them. This will make dragging the conversion to the entire column of cells quick and easy.
- Don't try to drag formulas over full cells. This will replace any data you currently have in those cells.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for