![]() If you were to subtract 35 hours from the cell C2, you’d use this formula: To subtract more than 24 hours, use this formula: If you were to subtract 4 hours from the cell B3, you would write the following formula: Let’s see how this would work on real data. You can use the following function to subtract less than 24 hours: However, with the latter, you can only subtract units less than 24 hours, 60 minutes, or 60 seconds. To subtract time, you can either use basic math calculations or functions. Note: If you change the value of any cell reference, the total will recalculate automatically. In this case, it’s the cell with the value you’re subtracting from the first cell: A6. Click on the second cell you want to reference.In this case, it would be the cell with the value you wish to subtract: A5. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |