Then type =SUM( into the cell, followed by the cells containing the times you want to add together. To use this function, select the cell where you want the sum of the times to appear. If you want to add two times together, you can use the SUM function. The combined time will appear in the cell without any spaces between the two times. Then type =A1&B1 if you wanted to concatenate cells A1 and B1 together. To do this, select the cell where you want the combined time to appear. You can also use the & operator to concatenate text and numbers together without using a function. The combined time will appear in the cell as text. Once you have selected the cells you want to combine and formatted them as text, close the parentheses and press Enter. You can also use other codes to represent different parts of a time, such as ss for seconds or d for days. The hh represents hours and mm represents minutes. For example, if you wanted to combine the times in cells A1 and B1, you would type =TEXT(A1,'hh:mm'),TEXT(B1,'hh:mm'). Then, type =TEXT( into the cell, followed by the cells containing the times you want to combine. To use this function, select the cell where you want the combined time to appear.

This function can be used to format a number or date as text. The combined time will appear in the cell.Īnother way to combine and format times in Excel is to use the TEXT function. Once you have selected the cells you want to combine, close the parentheses and press Enter. For example, if you wanted to combine the times in cells A1 and B1, you would type =CONCATENATE(A1,B1). Then, type =CONCATENATE( into the cell, followed by the cells containing the times you want to combine. This function can be used to combine text and numbers, or two numbers together. One way is to use the CONCATENATE function.

There are a few different ways to combine and format times in Excel.

Summing durations in excel