View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lori B Lori B is offline
external usenet poster
 
Posts: 1
Default custom date format

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!