I am getting a correct result using that exact data. You must have some issue with how you are entering that data into the cells.
Here is what I find on a Microsoft page:
QUOTE: In Microsoft Excel 5.0 and in later versions of Excel, you can enter times that exceed 24 hours by using a number format that includes [h]. The square brackets around the "h" instruct Excel to calculate times beyond 24-hour intervals, which allows you to enter times that exceed 24 hours. If you enter times that exceed 24 hours, Excel automatically applies a number format that includes the [h] code.
There are limits that apply to times that use this format. If you type a time value into a cell or use a formula to return a time that exceeds the limits, you may notice either of the following behaviors:
- If you enter a time that exceeds the limits, the time may appear as a text string.
For example, if you type the following time
20000:00:00 the time appears in the cell as a text string aligned to the left.
- If you use a formula to return a time that exceeds the limits, the formula returns a series of pound or number signs (####).
The maximum time value that you can type into a cell is 9999:59:59. If you type a value that is greater than or equal to 10,000 hours (10000:00:00), the time appears as a text string.
The maximum time value that you can calculate using a formula is 71003183:59:59. This value equates to 12/31/9999 23:59:59, which is the maximum time that you can use in Excel 2000. Unquote
That's exactly my problem: if you type a number of hours in excess of 9999:59, it returns a text string which you cannot use for additions, despite the correct formatting of the cell. However, if you use a formula (importing the numbers from another spreadsheet, for example, it seems to work). I would just like not to import the figures....
Thanks for your reply: I cannot understand why it works on your site: I tripled checked the formatting, etc... and it does not work, which seems in accord with Microsoft's quote...
