Hi , having a hard time formatting cells to just show total seconds rather than minutes:seconds format... So I tried to separate the data into 2 columns at the ":" and then convert "1" to 60, "2" to 120 etc.. but that isn't working either. Any ideas ? Example below. thanks

Data (time)
Cell A2= 1:15
Cell A3= 2:05

Desired result ( total seconds)
Cell B2= 75
Cell B3= 125