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

SUMIFS Function

The SUMIFS function sums numbers in Excel when they meet one or more specific conditions. SUMIFS is one of Excel's most widely used functions, and you will see it in all kinds of spreadsheets that calculate conditional sums based on dates, text, or numbers. Although a common function, ...Read more

Recent Articles

I'm a bit of a die-hard fan of Excel and your site. The way you help people isn't just in the provision of the information and the great layouts on your site; I've had promotions and secured employment knowing I have your site as a tool on my belt if I need it. I couldn't survive without it... lol.
Nicole
This site just saved my life today while importing data to a new database. THANK YOU!!!
Mary
I have been using Excel for years, but some of the functions I use sparingly and sometimes forget some of the finer points. For a quick refresher I visit Exceljet. It has become my fave place for quick refreshers.
Richard

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