Tom’s Tutorials For Excel: Calculating Elapsed Hours Between Start and End Times
Here are two formulas showing elapsed time in hours between a Start Time and an End Time.
In the first picture, the formula in cell E1 is =(B2-A2)*24.
You can format that cell as Number and set as many or few decimals as you like.
In the next picture, the formula in cell E2 is =ROUND((B2-A2)*24,2).
The num_digits argument is entered as 2 which sets the numeric value for two decimal places.
