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