Adding Times in MS Excel

You can add times in MS Excel using the =SUM worksheet function. All you have to do is enter all of your times as HH:MM:SS, and then use SUM to add them. You may omit the :SS if you like.

By default, Excel will display the sum of times in time-of-day format, such that adding 12:30 + 12:45 will give you a total of 01:15.

You can prevent MS Excel from rolling over at twenty-four hours by formatting the total cell as [h] :SUM, which will cause the total to display as 25:15 rather than 01:15.

Another way of adding times is to use the TIME function. Follow along below:

  • To add 2 hours, 30 minutes and 5 seconds to a time in cell A1, use the function below:
     

=A1 + TIME(2,30,5)

I am sure you will find reasons to use this latest tip.

When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

ad
ad