Hours Calculation in Excel

Hours Calculation in Excel

Hours Calculation in Excel

In this Microsoft Excel blog post, we will show you an Excel formula that allows you to calculate how many hours you have between two date’s example hours in a week, hours in a year.

As you can see, we wrote the first date in column A.

And then the second date is written in column B.

Then the formula is applied in column C, but after applying this formula you have to change the format of this cell as well.

To change the format you have to right-click in this cell then select the format cell option and in custom format [hh]:mm set it.

Now you will get the correct result of this formula.

Now I hope you have understood this simple formula.

Post a comment