Formatting Question


Laurence -

I hope the holidays find you well.

I have a question of formatting times. I have a spreadsheet with 20 columns, column number 3 and column number 4 are time formats (mm:ss) like 02:20 (for 2 minutes, 20 seconds).

When I run a stored procedure through analyzer and copy and paste my results in my spreadsheets the spreadsheets treats those columns as times. When I do an export through ASPOSE.Excel those columns come out as text fields and then I can not do any calculations on them.

Do you / Could you help me on how I should format those columns so they will stay time formats instead of text when they are imported.

Any help you can give will be greatly appreciated.



Hi Steven,

Could you email me your spreadsheet with those time columns? And please tell me how you export them. I will check this issue right now.