To calculate hours worked, enter valid time values into B2 and C2. For example, enter 11:00 PM as the Time In and 7:00 AM as the Time Out, and Excel will display 8, the correct number of hours ...

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 ...

How to Calculate Hours Worked Based on Salary. Salaried employees earn a fixed rate of pay no matter the number of hours worked. ... When Not to Use Excel. Excel can be used to do company payroll.