Format cell to change seconds to mm:ss

  • Thread starter Thread starter Larry White
  • Start date Start date
L

Larry White

I am working with data that shows time as a numeric in
seconds. (ex. 5'50" shows as 350) I need this to show as
mm:ss (ex. above 5:50) The mm:ss format does not do
this. How can I do this?
 
Hi
try the following
in an adjancet column (lets say B) enter the formula in B1:
=TIME(0,0,A1)
format this cell as time and copy this down

After doing this you can copy the formula results and paste them as
values ('Edit - Paste Specials - Values')
 
-----Original Message-----
Message unavailable
Click to expand...

Frank, thanks for replying, but as you can see your reply
came across as:
Subject:
From: Sent:




Message unavailable

Any idea how I can see your message, or could you just
drop me an email. Thanks.
 
Not sure why you can't read it in the Communities page, but it shows up when
read directly in the newsgroup.

Here's Frank's reply:

Hi
try the following
in an adjancet column (lets say B) enter the formula in B1:
=TIME(0,0,A1)
format this cell as time and copy this down

After doing this you can copy the formula results and paste them as
values ('Edit - Paste Specials - Values')
 
Back
Top