In this article, we will show you how to add Time in Microsoft Excel. How to add or sum the Time in Microsoft Excel. Here, we will describe the following two cases: When the sum is less than 24 hours.

In our case, we have to sum the data in the cells B2 to B6, hence, the formula is: =B2+B3+B4+B5+B6. Similarly, you can create a formula to subtract data in Excel.

You can subtract in Excel by placing a minus sign in front of any numbers you want to deduct. You can add and subtract a bunch of numbers at once using the equal sign or SUM function.