Formatting Question

  • Thread starter Thread starter Jason MacKenzie
  • Start date Start date
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
 
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
 
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
 
Back
Top