Thread: Convert from seconds to mm:ss within a cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default Convert from seconds to mm:ss within a cell
Hi
without VBA this is not possible within the same cell. ne
workaround: Use a helper column with the formula
=A1/(24*60)
and format this cell as time

-----Original Message-----
Hi, I need help.

trying to convert seconds i.e. 127 to read 2:07 while
still in the same cell.

Anyone know how to do this or even if it is possible
without writing VB code? TX
.

Reply With QuoteReply With Quote