Hi
I am having problems formatting cells where the data is a duration. When I use the following code:
cell.PutValue("0:24:34");
cell.Style.Custom=":mm:ss";
the generated Exel worksheet displays the data as "00:24:34" (it should be "0:24:34"), and when I examine the cell's format it is of type Number (-1234).
Ultimately I will have a column of these durations and I will need to create a formula to sum them and display that sum also in :mm:ss format.
Do you know what I am doing wrong?
Thanks
Alan