Question: how to create a formula in excel to calculate time?
Answer: Enter 6:45 in cell B2, and enter 9:30 in cell B3.
In cell B4, enter =B2+B3 and then press Enter. The result is 16:15—16 hours and 15 minutes—for the completion the two tasks. Tip: You can also add up times by using the AutoSum function to sum numbers. Select cell B4, and then on the Home tab, choose AutoSum.