Sometimes Excel doesn’t seem to add up the hours correctly. In this table I have made a table of an employee’s working hours and used the SUM function to add them together. Look what happens:
The sum is 13:45 instead of the expected 37:45. That’s 24 hours less than we wanted!
Here’s why: The result is actually 1 day, 13 hours and 45 minutes, but when you use the SUM function, Excel assumes that you want to keep the same format as above, which only shows hours and minutes.
How to fix it:
If you delete the contents of a cell in Excel, there is a risk that other parts of your workbook are affected by it. The easy way to prevent that from happening is to check if any other cells depend on the cell you want to delete. Here’s how to do it:
Select the cell, go to the Formulas ribbon and click on Trace Dependents. The arrows show the dependent cells.
Other Easy Tricks:
Are you using a non-English version of Excel? Click here for translations of the 100 most common functions.
Luckily, we don’t use the roman numerals much today, so this post is just for fun! Converting an Arabic number (normal number) into a Roman numeral is one of the easiest things you can do in Excel, but converting back from Roman to Arabic is equally difficult. Let’s have a look:
If you want to convert a normal number into a classic Roman numeral, there is a built-in function in Excel: ROMAN
In a previous post we learned how to make an Excel drop-down menu in 3 minutes. In this post I will show a very easy way to make a drop-down list in Excel that changes depending on what you have chosen in another cell. It’s easy, and it only takes five minutes!
It is absolutely critical that the data table is set up correctly: The main category (the countries in this example) should be in one column, and the sub-categories (the cities) in the other columns, with the countries repeated as headings.
READ MORE