I have two dates and I want to know the difference showing Days, Hours and Minutes.
I want to see in one cell 4 days, ? Hours, ?Minutes
<TABLE style="WIDTH: 325pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=432 border=0 x:str><COLGROUP><COL style="WIDTH: 107pt; mso-width-source: userset; mso-width-alt: 5193" width=142><COL style="WIDTH: 98pt; mso-width-source: userset; mso-width-alt: 4754" width=130><COL style="WIDTH: 120pt; mso-width-source: userset; mso-width-alt: 5851" width=160><TBODY><TR style="HEIGHT: 32.25pt; mso-height-source: userset" height=43><TD class=xl25 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; WIDTH: 107pt; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 32.25pt; BACKGROUND-COLOR: white" width=142 height=43 x:num="39609.841666666667">06/10/2008 08:12:00 PM</TD><TD class=xl26 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black; WIDTH: 98pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=130 x:num="39616.987037037034">06/17/2008 11:41:20 PM</TD><TD class=xl24 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black; WIDTH: 120pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=160>7 Days 209 Minutes</TD></TR></TBODY></TABLE>
I want to see in one cell 4 days, ? Hours, ?Minutes
<TABLE style="WIDTH: 325pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=432 border=0 x:str><COLGROUP><COL style="WIDTH: 107pt; mso-width-source: userset; mso-width-alt: 5193" width=142><COL style="WIDTH: 98pt; mso-width-source: userset; mso-width-alt: 4754" width=130><COL style="WIDTH: 120pt; mso-width-source: userset; mso-width-alt: 5851" width=160><TBODY><TR style="HEIGHT: 32.25pt; mso-height-source: userset" height=43><TD class=xl25 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; WIDTH: 107pt; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 32.25pt; BACKGROUND-COLOR: white" width=142 height=43 x:num="39609.841666666667">06/10/2008 08:12:00 PM</TD><TD class=xl26 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black; WIDTH: 98pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=130 x:num="39616.987037037034">06/17/2008 11:41:20 PM</TD><TD class=xl24 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black; WIDTH: 120pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=160>7 Days 209 Minutes</TD></TR></TBODY></TABLE>