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

If I have a lot of times to enter in m:ss format, I find it more
convenient to enter them as m.ss and then have a formula to convert
this format. If you entered 1.1 in cell A1 (meaning 1:10 - you don't
need to enter the zero), then this formula in B1 would give you 70
seconds:

=INT(A1)*60 + MOD(A1,1)*100

The formula can be copied down column B and then the times can be
entered in decimal in column A. You can pre-format column A to 2 dp so
the times look similar.

Hope this helps.

Pete