Your numbers with that formula would never generate an error to begin with. You needlessly use the MOD function because the formula B2-A2 is subtracting the earlier (former) from the later (latter). Or, from the MOD function, the result would be 1, the Remainder of the division operation.īut then you set up your time calculation table, with earlier (former) times in column A, and later (latter) times in column B. You propose to solve this problem using the MOD function, which returns the Remainder of an operation where a number is divided by a divisor. The problem, then, that this tip seeks to solve, is to find the difference between 6:00 today and 3:00 tomorrow because, as noted, ignoring the dates, 3:00-6:00 will generate an error. But 3:00 - 6:00 cannot equal -3:00 because there are no negative times, therefore Excel generates an error. You begin by stating that that an earlier (former) time must be subtracted from a later (latter) time to avoid an error. This method does not achieve the desired result.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |