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.
Make a common sum of formatted cells for hours
How to recover text files (.txt)? Exchange tips in the Forum.
How to Customize an Excel Spreadsheet