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 | Aug 22, 2020 | Formula & Functions, Worksheet Formatting
“DATE” is written in different formats in different countries, and sometimes even written differently in different parts of a country. You can maintain/change the date format as you wish by customizing the “Region and Language” settings of your windows operating...
by Rajesh Saraogi | Aug 7, 2020 | Formula & Functions, Worksheet Formatting
Microsoft Excel is a versatile and user-friendly application, most of the time, you find more than one solution to resolve a problem In one of my post, I covered trick to convert cardinal number and date to ordinal (ordinal-number-and-ordinal-date-in-excel) with the...
by Rajesh Saraogi | Jul 19, 2020 | Lookup & Reference, Worksheet Formatting
Goals: An excel worksheet is often used to update daily data. Suppose we enter per day sales by each engineer of the company in an excel worksheet. In such cases the number of rows is not fixed and extra rows are required to be added on daily basis. In turn you have...
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...
by Rajesh Saraogi | Jun 21, 2020 | Formula & Functions, Sum & Count
Goal: Excel worksheet have number of rows and columns. Intersection of row and column is known as a “cell”. We insert data in these cells only. Every cell has got a row number and a column number. We have to add value of every nth cell in a row or column. In simple...
