Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Date Format | Excel Discussion (Misc queries) | |||
Date format defaults to Custom | Excel Discussion (Misc queries) | |||
Looking for custom date format | Excel Worksheet Functions | |||
Custom format date | New Users to Excel | |||
Custom Date format ie. 01.01.05 W1 (W1 is week 1) | Excel Discussion (Misc queries) |