The dd format code returns the day of month for the value. Therefore,
the formated dd value will always be between 1 and 31. The day of
month begins at 1-Jan-1900, so after 31 days, it will roll back to 1,
indicating Feb 1, 1900. The dd format code does not support the
square bracket modifiers as do the hh and mm format codes.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]



On Fri, 11 Dec 2009 14:47:01 -0800, FSt1
wrote:

greetings all,
I have a file where i am tracking time. periodically a new line is added
with the new time. for reason difficult to explain, periodically, the time
gets reset to zero i.e. starts over. currently i am using format dd:hh:mm:ss
this works well but occasionally the time runs beyond 30 days(1 month) and
the above format resets to day 1 when it goes beyond 30 day(1 month?). i have
tried dilffernts format to try and make the days roll over ie 35:00:00:00 but
to no avail.
[dd]:hh:mm:ss doesn't work.
can someone give me some pointers/tips/directions on my dilima.

help would be most appreciated.
regards
FSt1