as

How to add hours in Excel

Excel allows you to do automated calculations to add and subtract values in cells, including hours. The feature works similarly to the sum of common integers, but has its peculiarities. When feeding an hour bank spreadsheet, for example, you have to make some adjustments so that the program does not get confused and end up showing wrong times. Here's how to add and subtract hours without missing the count in Microsoft's spreadsheet processor.

Seven Excel functions that few people know about

Learn to add and subtract hours to work out worksheet

Want to buy cell phone, TV and other discount products? Know the Compare

How to add and subtract times

Step 1. In a time bank spreadsheet that marks in and out times, check all the cells that will contain this information and go to the "Format cells" menu;

Mark the cells and go to the formatting menu

Step 2. In the "Category" menu on the side, select "Custom" and, in the "Type" field, type: [h]: mm; ". Then press "OK" to go ahead and set up the worksheet for hours;

Format cells to handle time data correctly

Step 3. Normally fill cells with time of entry and exit. In the column that marks the total hours worked on the day, use the SOMA tool to subtract between the highest and lowest hours. In the example, the formula would be: = SUM (D6-C6);

Subtract the highest time from the lowest hour

Step 4. If the calculation has more than one range of hours, separate the turns in different brackets: = SUM (D6-C6) + (F6-E6). Remember to always put the time later in front of each subtraction;

Use parentheses to separate different time intervals

Step 5. When entering Enter, the cell of the last column should display the total count of hours worked on the day;

Enter to get the sum of hours worked on the day

Step 6. Next, just click on the first cell of the count column and drag to the end to replicate the same formula for the other rows.

Copy the time counting formula to other lines

Adding and Subtracting Amount of Hours

If a time sheet counts only the amount of time worked, the sum can be done more directly.

Step 1. First, check the worksheet cells that will contain time data and go to the formatting menu. Then type: [h]: mm; @ in the "Type" field;

Format cells to handle time data correctly

Step 2. Create a column next to the count of hours and use the sum tool to count the total amount of hours worked. In the example, simply add the cells in any order.