How to Calculate Hours Between Dates in Excel | Real Practical Example | Logistics Delivery Sprea...
🟢 LEARN EXCEL WITH ME AND BECOME A REFERENCE IN THE JOB MARKET: http://excelentejoao.com.br/sejaexcel...
#Excelentejoao #Excel #Dashboard
In this Excel video, we will learn how to calculate hours between dates in Excel. So, in this free Excel tutorial, we will see how to work with calculating hours in the Excel spreadsheet.
This practical and real example can help you a lot in your day-to-day life and in the job market with Excel.
It is very common for Excel to present an error when we subtract negative hours, or even when adding hours with more than 24h, or even in other situations with hours in Excel.
Therefore, this simple and easy tip can help you how we can calculate the number of hours between two days or between two dates in Excel.
Basically, we need to make some text formatting and data display settings. We will need to use the format 37:30:55, this way, Excel calculates more than 24 hours and does not get stuck in just 24h, always returning to zero hours whenever it reaches 23:59.