Hi,

This is a rather unusual format d:h:mm, what do you want the results to look
like, give us an example.

d stands for single digit days and runs from 1 to 31 (the number of days in
a month). I don't think you can create a format which does exactly what you
want, but you can create a formula in a cell which display the way you want.

=INT(C4)&":"&TEXT(MOD(C4,1),"hh:mm")

where C4 is you cell you wanted to format.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Lori B" wrote:

I am already using a custom date format of d:h:mm for a field where I am
calculating the networkdays from one date & time to another. I want to be
able to add these fields, however, if it exceeds 31 days it does not maintain
the number of days but starts over. How can I build a custom format to
recognize the total number of days? I have tried to put bracket around the
number of days to show as [d]:h:mm but it does not work. Any help would be
appreciated!