Convert days, hours, minutes, seconds in Excel

by

It is possible to apply various conversions between time units in Excel. For instance, converting days to hours, hours to minutes, minutes to seconds and so on. These can be reversed as well. All these conversions can be done by basic mathematical operations, or using a built-in function, called CONVERT function. We know that 1 hour … Read more

GCD & LCM Function in Excel

by

GCD and LCM help to simplify calculations, and solve problems involving “Fractions”, “Time and Distance Problems”, “Solving Equations” and in various contexts. In this article, you will learn how to calculate greatest common divisor and least common multiple by using GCD and LCM function in Excel. GCD function and how to use it in Excel … Read more