![]() ![]() In the previous example, we have seen how many hours an employee has worked using the normal arithmetic formula now, in this example, we will use the time function in 24 hours format. In the above example, we can see the time difference in how many hours an employee has worked and the breakup timings given for each employee as time OUT. We just need to drag the cell H2 downwards, and the formula will be applied to all the cells.By applying this formula, we will know how many hours an employee worked for a day, and the output will be displayed as follows.Hence we can use the simple Excel timesheet formula as =(E2-D2)+(G2-F2). If we have IN and OUT Timings, we can use the formula as shown above, but we have BREAK TIME IN and TIME OUT in this example.After applying the format, we will get the output result as follows.Once we click on the format cell, we will get the dialog box below, choose the exact time format, and click ok.We need to change this general format to time by formatting the cell, as shown below.By default, Excel will return the result in decimal numbers, as shown below, where it’s not an exact number of hours. ![]() To calculate an employee’s no of hours, we will calculate the formula as OUT TIMINGS – IN TIMINGS.Make sure that the cell is in the proper time format.First, create a new column named Number of Hours Worked.Now we need to find out how many hours an employee worked by following the below steps: The above employee database has a date, employee name, TIME IN, and TIME OUT. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |