LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roger
 
Posts: n/a
Default converting Minutes to Seconds

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
converting seconds into minutes LondonLion Excel Worksheet Functions 3 February 10th 06 06:17 PM
How do I sum increments of minutes and seconds SandyMichalski Excel Worksheet Functions 5 February 2nd 06 03:02 PM
Converting minutes to seconds Saray Excel Discussion (Misc queries) 4 September 9th 05 05:51 PM
Sum minutes and seconds to total hours deck4 Excel Discussion (Misc queries) 3 August 29th 05 02:34 PM
converting from digital degrees to degrees minutes seconds Patricio Boric Excel Worksheet Functions 1 November 28th 04 07:43 PM


All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"