Subtracting Minutes From Time in Excel

Microsoft Office Excel is available for all computers running Windows or Mac OS X.
••• Joe Raedle/Getty Images News/Getty Images

Subtracting time units in Excel is useful for measurements such as the length of an event or for determining the current date and time in different parts of the world. Before performing such a subtraction, you need to change the format of the two cells that are part of the operation. Finally, you can use a third cell to display the result.

    Click on the cell that will contain the value from which you want to subtract minutes. Select "Format" from the Cells section and click "Format Cells" to open the cell format settings.

    Press "Custom" and type the desired format for the cell in the Type box. Use "hh" for hours, "mm" for minutes, "ss" for seconds and "AM/PM" if you want to represent the clock time. For example, if the cell will hold a value such as "1:30 PM" you would type "h:mm AM/PM" (without quotes here and in subsequent commands). Alternatively, to display time units like "30 hours, 2 minutes and three seconds" you should use "hh:mm:ss" as the format.

    Press "OK" to save your preferences and repeat the process for the second cell. As this cell will contain the amount of minutes you want to subtract from the first value, use the "hh:mm:ss" format.

    Insert the time values in the two cells. For example, if you want to represent one hour and 30 minutes in the second cell, you should type "1:30:00."

    Double-click a third cell, which will hold the result of the computation. Type "=cell1-cell2," where cell1 and cell2 are the first two cells. For example, if you used cell A1 to hold the first value and cell A2 for the second one, you would type "=A1-A2." Press Enter to display the result.

Related Articles

How to Express "Divisible By" in Excel
How to Convert CM to Inches in Excel
How to Calculate the Percent Change in Excel
What Does ##### Mean in Excel?
How to Calculate Correlation Coefficient Between Two...
How to Use a TI-84 Plus
How to Find Zeros of Functions in Excel
How to Read a Time Clock in Hundredths of an Hour
How to Subtract Matrices on Excel
How to Decrease Digits in Excel
How to Draw an Array in Math
How to Solve by Simpson's Rule With Excel
How to Graph a Distribution for a T-Test
How to Build You Own Battery Pack AA 9 Volt
How to Create Matrices on a TI-89
How to Make Frequency Tables
How to Do Algebra in Excel
How to Do Sixth Grade Math Ratio Tables
How to Make a Semi-Log Graph on Excel?
How to Create a Normal Distribution Graph in Excel