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
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
num_digits argument is entered as 2 which sets the numeric value for two decimal places.