The second IF statement calculates the hours worked after lunch. The first IF statement calculates the hours worked before lunch. In cell E2, enter the following formula:.Right-click cell E2, and click Format cells from the pop-up menu.When used with the SUM function, it can be used to calculate the number of hours worked minus an hour for lunch break. This same formula can be used to calculate hours worked for the day shift. In cell C2, enter the following formula:Įxcel displays 8:00, the correct number of hours worked this shift.Select 13:30 from the Type list box, and then click OK.Right-click cell C2, and click Format cells from the pop-up menu.Select 1:30 PM in the Type list box, and then click OK.On the Number tab, select Time from the Category list box.Right-click the selected cells, and click Format cells on the pop-up menu.Fortunately, you can create a formula that correctly figures the hours worked for any shift. To calculate hours worked in Excel, you can usually just subtract the start time from the end time-as long as the work shift doesn't span over midnight. If you need to calculate hours worked for the 11:00 PM to 7:00 AM shift, simple subtraction won't do.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |