3. Calculating Time Duration. To calculate the duration between two times in hours, minutes and seconds: Step 1: Enter your start time (cell C1) and end time (cell C2) in a “HH:mm:ss” format. Step 2: ...

There are two other methods to use the DURATION function in Excel. Method one is to click the fx button on the top left of the Excel worksheet. An Insert Function dialog box will appear.

If you want to sum up the total number of hours using an Excel formula to calculate time worked, place a formula at the bottom of that column using the SUM function, summing up each row's entry ...