![]() ![]() Some date values include both a date and time, and are sometimes called "datetimes". This is important, because Excel won't display negative time values. greater than 24 hours).Įven better, if we end up with a negative fractional value, MOD returns the reciprocal. MOD returns the remainder after division, so returns the decimal value in cases where the result is greater than 1 (i.e. ![]() ![]() To make sure we get just the decimal value, we use the MOD function with a divisor of 1, as a clever way to keep the formula simple. In other words, if we add 12 hours (.5) to 6 PM (.75) we'll get 1.25, but we really only want. ![]() To make sure we have a true time value, we need to ensure that we have only a decimal value.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |