Expand To Show Full Article
Add or Subtract Time in Excel - Developer Publish Tutorials

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