This is because the times when the employee started and finished work span midnight. Simple calculation of hours worked for each day of the week has been done!Īs you can see, the result for Friday displays only a set of hash signs. If you want to calculate hours worked for each day of the week, simply click on the bottom right corner of the cell containing the formula and drag down the cells where we need the formula to do the calculation, too. How to Calculate Hours Worked in Excel (whole week in a minute) Press ‘Enter’, and we’ve got the result! On Monday, the employee worked nine hours and thirty minutes in total.
Since we’re subtracting, insert the minus and now just add the time logged under ‘Start Work’. Type in the ‘equal’ sign and click on the cell that contains the later time value, which means 4:30 PM here. If the cells have been formatted as needed, click in the cell where you want the result to appear. If you want to know more about how to set the right formatting, watch our video on how to insert and format time in Excel. Formatting of the cells in this table was set in the previous tutorial. If Excel is to subtract time accurately and to display the right time format, cells must be formatted properly before the calculation takes place. Hours worked can be calculated easily, as time difference – simply take the later time and subtract the earlier one. The table we prepared contains the time when an employee started and finished work.
0 kommentar(er)
