Thread: [Solved] Challenge summing time (mm:ss) values?
View Single Post
 
Old 12-15-2014, 10:53 PM
Mr Davo Mr Davo is offline Windows 7 64bit Office 2010 32bit
Novice
  
Join Date: Jun 2011
Posts: 20
Mr Davo is on a distinguished road
Default Challenge summing time (mm:ss) values?
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/...for-Excel.xlsx

Any help will be greatly appreciated.

Kind Regards,

Davo
Attached Files
File Type: xlsx Time-for-Excel.xlsx (11.5 KB, 11 views)
Last edited by Mr Davo; 12-16-2014 at 05:36 PM.
Reply With Quote