From time to time, people approach me with an Excel problem that looks easy to calculate while, unfortunately, there’s no straightforward solution to it. The problem is calculating the difference (in hours) between two date-time formatted cells. Example: Cell A1: 2/15/2012 10:00:00 AM Cell B1: 2/18/2012 08:00:00 PM What is the elapsed time between both