Difference between two dates and times

[mak1452]

I need a formula that will calculate between to dates and times. For example <TABLE style="WIDTH: 144pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=192 border=0 x:str><COLGROUP><COL style="WIDTH: 72pt; mso-width-source: userset; mso-width-alt: 3510" width=96><COL style="WIDTH: 72pt; mso-width-source: userset; mso-width-alt: 3510" width=96><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 72pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right width=96 height=17 x:num="40353.892361111109">6/24/10 21:25</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 72pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right width=96 x:num="40343.920138888891">6/14/10 22:05</TD></TR></TBODY></TABLE> I need it to tell the amount of days, hours and minuits between these two dates. Thank you very much

 

[xld]

Use

=A2-B2

and format as

d "days" h "hours" m "minutes" s "seconds"

 

[mak1452]

Thank you so much you are a life saver!!!!!!!!