The TIME function stores hours in the first argument, minutes in the second argument, and seconds in the third argument. In those cases, the TIME Function is very effective. There are some times we need to subtract a specific amount of hours from a time period. Less 'clever' perhaps, but 'clever' has a way of coming back to bite. Subtract Time with TIME Function in Excel. That would be a far more robust and reliable method. the fourth column, the running balance, in which your IF conditional formula is based on the contents of that second column, adds if it's a credit subtracts if debit.a second column with a drop-down (data validation) selection offering 'Credit' or 'Debit'.a single column that is headed 'Description', which could contain any of those words as well as any others that might come along.what about some category or description that is brand new?.What happens if it's 'fuel' instead of 'gas'?.
What happens, for example, if somebody enters 'entertanment' or 'entertainment ' (a misspelling or a hidden space)?.I'm not mistaken, given that you were just giving examples, the actual criteria lists for debits/credits will be longer and more varied.Īnd that could mean that this approach is potentially setting you up for frustration and difficulty.
