• Free Excel Calendar with Powerful Reminder feature.

    We have a free Excel calendar to share with all our visitors.   It covers  years 2013-2019. You can add/edit Events. Great Reminder feature. Weekly/Monthly views. Simple Input Forms so no knowledge of Excel required. Works on all Excel Versions   Click Here to Download  it Please feel free to share this with all your Excel using friends via our […]

    Free Excel Calendar with Powerful Reminder feature.
  • How to copy Formulas without them changing.

    A common problem when using Excel formulas is how to copy a formula or a set of formulas and paste them to a different location, keeping their references as they are. When you copy a formula, Excel adjusts the cell references used in the formula to the new location using its default concept of 'Relative Reference'. Now usually this adjustment […]

    How  to copy Formulas without them changing.
  • How to combine formulas into a single formula?

    Often you can be using formulas that use or depend on other formulas, which in turn use or depend on other formulas. In some cases, these intermediate formulas are required to remain in separate cells, while in other cases these formulas can be "merged" into the final formula, thus creating a single, large formula. There are advantages and disadvantages in both […]

    How to combine formulas into a single formula?
  • Essential Excel: The Powerful INDEX & MATCH Functions in Excel.

    The Index & Match Function: The INDEX Function can return an item from a specific position in a table. The MATCH Function  returns the  relative row position of a value in a list. The INDEX and MATCH Functions are often  used together, as a flexible and powerful tool for extracting data from a table. The VLOOKUP Function can only search […]

    Essential Excel: The Powerful INDEX & MATCH Functions in Excel.
 

Essential Excel Concepts »

Essential Excel: Excel Time arithmetic.

March 11, 2013 at 5:34 pm

The key point to remember when dealing with Time in Excel is that it is a portion of a date value and represented by a decimal number (for example, 12:00 PM is represented...