Formatting Question

J

Jason MacKenzie

I'm using Excel 2003.

I'm pasting some data from an ASP.Net datagrid into a worksheet. One column
called Duration could have a value of 11:31 in it - which means 11 minutes
and 31 seconds

If I double click in the cell it changes to 11:31:00 AM which I don't want
it to do at all. Or if I try to format it as General it gives me
0.479861111111111. Formatting as text gives me the same result.

I'm confused as to why its doing this.

Thanks,

Jason MacKenzie
 
F

Frank Kabel

Hi Jason
Excel interprets your value as HH:MM and not as MM:SS
Try the following:
- enter the value 60 in an empty cell
- select this cell and copy this cell
- select your imported values
- goto 'Edit - Paste Special' and choose 'Divide'
- format these cells with the custom format
mm:ss
 
A

Andy B

Hi

Excel must handle dates and times in a different way to the donor software.
One solution is to divide the cell by 60. If you have a range of cells to do
you can do it in one go:
Type 60 in a blank unused cell
Copy this
Select the range and then Edit / Paste Special / Divide
 
Top