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 post, you’ll learn how to Find Blank cells in excel so that you can remove or delete the blank cells form...
In this article, you’ll learn what is a Gauge Chart in Microsoft Excel. Also, you will learn how to add...
Microsoft Excel provides a shortcut for the users to move columns in excel using two different ways – using Shift...