Hello

Issue with adding time (researched site and cpearson and still can’t resolve)

Raw data is exported from a database (engine unknown – large multi user organisation). Export facility has many format options in addition to Excel.

Excel options range through ‘Excel 2.0’ to ‘Excel 5.0’ and also csv. Current raw data exports done in both Excel 4.0 & 5.0 and issue with both.

Example column of times to Sum are shown thus (number of rows varies but approx 30):

489:55:06
311:33:53
165:26:51

Underlying cell format on export is ‘General’. Cells reformatted to hh:mm:ss. Cell for Sum function formatted to [h]:mm:ss.

Result – 0:00:00

Manually overtype the data cells – Result 966:55:50 which is correct.

Data cells change on over type so reformatted these to [h]:mm:ss to maintain

Get the result required but would like to know why I have to manually re-enter to do so?

Tried formatting sheet in new workbook with [h]:mm:ss and use ‘paste specia’l, ‘values’ to place raw data into it from the export (rather than re-formatting within the Excel export) and same issue.

Any thoughts out there?
(Excel used - 2002 SP3. Think its 2003 at work)