How to use Time FORMULA in Excel
Enter the start date and time in cell A2 and hit Enter. ...
Enter the end time in cell B2 and hit Enter.
Enter the formula =B2-A2 in cell C2 and hit Enter. ...
Right-click on C2 and select Format Cells. ...
Choose the Custom category and type “h:mm”