Featured Formulas

Calculate hours between two times

In this example, the goal is to calculate the difference between two times in Excel in hours and minutes. This basic problem comes up frequently when tracking time and may be described in various ways:

  • Calculate elapsed working time in hours.
  • ...Read more

Featured Functions

IFS Function

The IFs function evaluates multiple expressions and returns a result that corresponds to the first TRUE result. You can use the IFS function when you want a self-contained formula to test multiple conditions at the same time without nesting...Read more

Recent Articles

I was looking for a way to make SUMPRODUCT conditional, if possible, and your page https://exceljet.net/formula/sumproduct-with-if came up at the top of my Google search. I would like to say that this solution is absolutely genius - it works a treat! It is so easy to implement too.
Adam
You are fabulous!!! It worked perfectly! Thanks a million :) :)
Gloria
I found your site several times and now always use it first. Thanks for making it easy to understand and apply. I subscribed to the newsletter as well.
Anita

Get Training

We offer free resources and paid training.

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed.

View Paid Training & Bundles

Just show me the free stuff

Excel 101 and Core Pivot Packages