Use Excel to calculate the hours worked for any shift - OneSite

Breaking

EVERYTHING IS HERE

Post Top Ad

Post Top Ad

Saturday, October 20, 2018

Use Excel to calculate the hours worked for any shift

With Excel, you can create a worksheet that figures the hours worked for any shift. Here's how.
However, you can easily create a worksheet that correctly figures the hours worked for any shift.
Follow these steps:
  1. In A1, enter Time In.
  2. In B1, enter Time Out.
  3. In C1, enter Hours Worked.
  4. Select A2 and B2, and press [Ctrl]1 to open the Format Cells dialog box.
  5. On the Number tab, select Time from the Category list box, choose 1:30 PM from the Type list box, and click OK.
  6. Right-click C2, and select Format Cells.
  7. On the Number tab, select Time from the Category list box, choose 13:30 from the Type list box, and click OK.
  8. In C2, enter the following formula:
=IF(B2
If you enter 11:00 PM as the Time In and enter 7:00 AM as the Time Out, Excel will display 8, the correct number of hours worked.

No comments:

Post a Comment

Post Top Ad