Challenge summing time (mm:ss) values?

[Mr Davo]

Hi Everyone,

I am trying to sum times (mm:ss) in Excel 2010 and I am getting nowhere quick. No matter what I seem to try, and I have poured over the internet trying a variety of methods, I am either getting the result 0:00:00 or 2:25. I have taken the liberty of linking to a section of the troublesome sheet, and it would be great if somebody could offer some advice on how to make the summing of the 'Duration (minutes)' column behave itself!

https://dl.dropboxusercontent.com/u/92436355/Time-for-Excel.xlsx

Any help will be greatly appreciated.

Kind Regards,

Davo

 

[Macropod]

Try:
=SUM(TIMEVALUE(B2:B113))
entered as an array formula (Ctrl-Shift-Enter)