![]() However, I have a fixed time in A1, not the actual time. Excel will close the parenthesis for you automatically and perform the calculation. 1 3 Are you doing A1-TIME (5,0,0) where A1 has the start date/time In A1 I put now (), and then in A2 I put A1-TIME (5,0,0) which results in A2 showing now - 5hrs spikeyrichie at 16:12 Hi, thanks for a quick response. While holding the mouse button, drag the mouse from A1 all the way to A10. That is an equal sign, the word SUM, and an open parenthesis.ģ. ![]() Click the cell where you want the final result to appear (such as A11). Remember that any numbers you want to subtract should have a minus sign ( -).Ģ. Enter the numbers you want to use in each cell from A1 through A10. In fact, this function can combine addition and subtraction into a single operation - you simply need to put a minus sign in the cell of every number you want to subtract (this means the number will look like a negative number).ġ. Using the SUM function, we can calculate the result easily. Suppose you have a set of numbers stored in cells A1 through A10, and you want to subtract them. ![]() You can use the previous technique to subtract cells, but if you have several cells you want to subtract, there is an easier method - you can subtract a range of cells all at once. How to subtract a range of numbers in Excel
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |