I need to calculate the actual resolution time in 'Days:Hours:Minutes' format, for the work requests which are being worked upon by the engineers working in my team. I am using MS-Excel (MS-Office 2013) for reporting. The tool from which I am exporting the details shows the Open and Resolved time as MM/DD/YYYY HH:MM:SS (3/20/2015 10:32:16 AM). I am sure this is one of the thing which is not that difficult and many reporting people are doing this. Thanks in advance for the a

Let's say that the Open date/time is in A2 and the Resolved date/time in B2.

The formula for the resolution time is =B2-A2

Format the cell with the formula with the custom number format d:hh:mm

This will work as long as the number of days is at most 31.