HomeMicrosoft OfficeExcelAdd or Subtract Time in Excel

Add or Subtract Time in Excel

In this article, you’ll learn how to add or subtract time in Excel using various built-in functions in Microsoft Excel.

Excel has predefined functions to perform these operations. Let’s take a look at the ways these operations can be performed.

Time function

You can simply add or subtract time using this function. You can add or subtract hours, minutes, and seconds to a time using this function.

Add or Subtract Time in Excel

SUM function

You can also add up times using SUM function. The function goes like =SUM(cell references), references that refer to the cell containing timings.

Add or Subtract Time in Excel

Subtract Minutes

You can subtract minutes using the TIME function as shown below.

Add or Subtract Time in Excel

Time Difference

You can use the simple subtract (minute) operator to find the time difference in Excel.

Add or Subtract Time in Excel

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021