Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 vs. 2003 differencies for custom format [h]:mm:ss
Hi,
In one column (Excel 2003 Xml Spreadsheet document) we have cells with duration data. Some cells are formatted as "h:mm:ss" (when duration is less or equal to 24 hours) and some as "[h]:mm:ss" (when duration is longer then 24 hours). We did it in order to display durations correctly when the document is open in Excel 2007. Otherwise, Excel 2007 adds 240 hours to duration if we use only "[h]:mm:ss" format. The trick with mixing formats works for displaying these durations. But it does not work for sorting and charting, since Excel 2007 still adds 240 hours to every duration formatted "h:mm:ss". Please help. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel opens two windows (2007 & 2003 format): I want only 2003. | Excel Discussion (Misc queries) | |||
Excel 2003. Custom format gets replaced by Special format. | New Users to Excel | |||
2003 - 2007 custom macro and custom button restore. | Excel Discussion (Misc queries) | |||
Custom toolbars and Excel 2003 - 2007 portability | Excel Programming | |||
Custom Number Format Excel 2003 | Excel Programming |