Format cell to change seconds to mm:ss

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?
 
F

Frank Kabel

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')
 
L

Larry White

-----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.
 
D

Dave Peterson

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')
 
Top