D-DAY TODAY
04/01/2008 05/14/2007


322 days 9 hrs 23.0 min 24 sec
0\days [h]\hrs m.0\min ss\sec

in the above worksheet, I calculate the difference betweeen two dates.
I have formatted the cells to display only days, hours,& seconds
successfully. I am having problems with the minutes format, everytime
I take the decimal part out, it revervts to 1 min regardless of the
actual value.