View Single Post
 
Old 12-17-2014, 05:59 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 32bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

Hello Davo

Your column B isn't the mm:ss that you think it is. It is actual time based on the 24 hour clock, ie: B2 is 9:05 PM.

In C2 put =TIME(0,LEFT(B2,LEN(B2)-3),RIGHT(B2,2)) *24*60 to get minutes with a decimal, drag down, then sum the column as normal.

Good luck
NoSparks
Reply With Quote