In this tutorial you will learn that how you can calculate time in Excel using a simple subtraction formula. The first way to convert a time value to hours minutes or seconds number is to use the multiplication formula. Using the TIME function Using arithmetic calculations based on the number of hours 24 minutes 1440 and seconds 86400 in one day.
The information has to be entered into Excel in a correct time format for the formula to work.
Step 3 Now we want our cell to be in the correct format so right-click on the cell and go to the format category. On the Home tab in the Number group click the arrow next to the General box and then click More Number Formats. Calculate hours worked with Excel Timesheet Formulas - 4 steps. The information has to be entered into Excel in a correct time format for the formula to work.