Place the cursor in cell C15. A step-by-step guide Step 1. We can add time in excel using the SUM function or do individual addition using the operator.
Sum function in excel is an inbuilt function which is used to sum numerical values present in a range of cells it is a mathematical formula in excel which can be used by typing SUM keyword in the cell where we want the sum to be calculated and then we select the range of cells which are to be added.
SUMIF supports logical operators and wildcards for partial matching. When this is the case we use Custom Number Format. Use the SUM function in Excel to sum a range of cells an entire column or non-contiguous cells. SUMIF Formula in Excel.