Step 4: Get the subtotal of working hours, overtime, and earned money: Step 3: Calculate the total money of every day: In Cell J2 enter =F2*G2+H2*I2, and drag the Fill Handle down to the range you need (in our case, drag to the Range J2:J7.) If your working hours are not 8 hours per day, please change the 8 to the number of your working hours in both formulas. Note: We normally work for 8 hours per day. (2) In Cell H2 enter =IF((E2-D2)*24>8,(E2-D2)*24-8,0), and drag the Fill Handle down to the range you need. In our case, we apply the formula into Range F2: F7. (1) In Cell F2 enter =IF((E2-D2)*24>8,8,(E2-D2)*24), and drag the Fill Handle down to the range you need. Step 2: Calculate the working hours and overtime with formulas: Step 1: Prepare your table as the following screen shot show, and input your data. To create a billable hour table and save as an Excel template, you can do as following:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |