View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Roger
 
Posts: n/a
Default converting Minutes to Seconds

On Mon, 20 Mar 2006 22:43:03 -0000, "Paul Lautman"
wrote:

Roger wrote:
Hi,

How do I convert 1:10 in one cell to 70 seconds or just 70 in another
cell.

Or better yet; is there a way to enter 1:10 into a cell and have it
change to 70 automatically? Can this be done without a macro?

Thanks.


1:10 is 1 hour and 10 minutes
00:01:10 is 1 minute and 10 seconds

To convert the former to seconds ,multiply it by 86400



Thanks I made a mistake. What I want to do is enter one minute and
ten seconds into a cell without having to enter (00:1:10:0) and have
it come out as 70 seconds. I want to enter either 110 or 1:10.

Can that be done?

Thanks.