Help with Format cells to display minutes difference
Here are the constants from the VBA help file:
h Display the hour as a number without leading zeros (0 €“ 23).
Hh Display the hour as a number with leading zeros (00 €“ 23).
N Display the minute as a number without leading zeros (0 €“ 59).
Nn Display the minute as a number with leading zeros (00 €“ 59).
S Display the second as a number without leading zeros (0 €“ 59).
Ss Display the second as a number with leading zeros (00 €“ 59).
I don't see the m.0 reference, or am I reading your example wrong?
"Titus" wrote:
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.
|