by Rajesh Saraogi | Sep 1, 2020 | Date & Time, Formula & Functions
A number of options are available for adding time in Excel. We may use built-in functions “TIME” or “SUM”, depending on how we have recorded the time in the worksheet. Excel allows us to capture “Hour”, “Minute” and “Second” in separate cells as well as in one too....
by Rajesh Saraogi | Jul 5, 2020 | Date & Time, Formula & Functions
Goal: To get difference between two dates with the answer as exact year, month, and days. Simply it means, if we take two dates as 1-Jan-2009 and 2-Feb-2010, the required result (difference) will be 1 year 1 month 1 day. Algorithm: First of all we have to check...
