Minutes and Seconds

  • Thread starter Thread starter Lynn
  • Start date Start date
L

Lynn

I exported a spreadsheet that contains mm:ss (1:10), but
when I pull it up in Excel it shows 70. Like it added
the minutes and seconds. How can I convert this back to
look like 1:10?

Thanks
 
put 86400 in an empty cell, copy it, select the imports, do edit>paste
special and select divide.
Format custom as [mm]:ss or regular format hh:mm:ss which will return
00:01:10
 
Thank you SO much. You don't realize how much work you
just saved me.

Thanks again
-----Original Message-----
put 86400 in an empty cell, copy it, select the imports, do edit>paste
special and select divide.
Format custom as [mm]:ss or regular format hh:mm:ss which will return
00:01:10

--

Regards,

Peo Sjoblom

I exported a spreadsheet that contains mm:ss (1:10), but
when I pull it up in Excel it shows 70. Like it added
the minutes and seconds. How can I convert this back to
look like 1:10?

Thanks
Click to expand...


.
Click to expand...
 
Back
Top