In cell C2 enter the simple subtract formula =B2-A2 and custom format the
formula cell as below

d:[h]:mm

--
Jacob (MVP - Excel)


"MsLearner" wrote:

Hi,

I am working on data sheet and having to columns like Must be Solve Date and
Actual Solve date i want to find diffrence between these 2 in days:hrs:mints
in result column.

sample i have provided below. can some one help me what formula can bring be
exact diffrence in days:hrs:mints in Excel 2007

Must be reacted WasReacted Delay in Reaction
5/10/2010 6:05 5/10/2010 4:17
5/10/2010 7:43 5/10/2010 5:50
5/10/2010 9:22 5/10/2010 7:24
5/10/2010 10:30 5/10/2010 8:38
5/10/2010 11:10 5/10/2010 9:19