Invest 4 minutes to learn about 3 functions by watching Excel Video 191. The payoff will be next time when we use all three to convert minutes to an hours:minutes format.
INT simply rounds a number down to the nearest integer.
LEN calculates the length, or number of characters in an expression.
MOD calculates the remainder after dividing two numbers. For example 124 divided by 60 is 2 with a remainder of 4. MOD gives you the remainder, or 4 in our example.
What does all of that have to do with converting minutes to hours:minutes? Stay tuned. Investing in understanding those three functions make Excel Video 192 much easier.
