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.