Just a caution -

That will work for sums less than 32 days, and only if your users are
guaranteed to only use the 1900 Date system.

The "d" format refers to the "day of the month".

In the 1900 system, the base date is 31 December 1899, so 1.000...
refers to 1 January 1900.

However, if your user is using the 1904 date system the base date is 1
January 1904, and 1.000.... is interpreted as 2 January 1904, so your
results will appear to be off by 1 day.

And of course, in either system, values greater than 31 will roll over
to February, etc.


In article ,
"Fred Smith" wrote:

Simply change the format to include the days, as in:
d hh:mm
or, just:
d