DEFINITION :- SUMIF is a inbuilt function in excel which sum up the multiple values in a proper range with proper given criteria. TIME function is also a inbuilt function which used to measure the time or display the time in excel. In this example we will use SUMIF function to sump up the time values from a different cell on a particular criteria.
To know more about sumif and sumifs please check this post SUMIF IN EXCEL & Also SUMIFS IN EXCEL
NOTE:- Make sure you have time format set for the output cell. please check the image below.
![](https://excelhelp.in/wp-content/uploads/2020/12/SUMIF-TIME-IN-EXCEL-1-1024x555.png)
![](https://excelhelp.in/wp-content/uploads/2020/12/SUMIF-TIME-IN-EXCEL-1024x551.png)