How to calculate hours between 2 dates.

I tried =A1-A2 but got no result. I had the cellels formatted as date.

A1-A2 should have worked -- as long as the dates were numbers. If A1-A2 does not work, it is most likely because the "dates" are really text strings (number formatting cannot change the cell value, so it cannot make a number stored as text a number). The key step in this operation, then is converting the dates stored as text to real numbers that Excel can work with. Power Query is one way. Other strategies are here: https://support.microsoft.com/en-us/...1-c5bad0f0a885 Some strategies depend heavily on your system's regional settings for what a date will look like.

Several different ways to do this, but you need to get your dates stored as numbers and not text to make it easier for Excel to work with your dates.

Perhaps

Formula:

Please Login or Register  to view this content.

and format as time