Totals for mm:ss

[projectile]

Hi

i have download a skype call report in CSV , which has a column called duration. This column is formatted in minutes : seconds e.g.

Duration
10:44
03:57
00:00
02:38
01:11
00:50
02:34
03:36
02:50
03:26
01:00


I need to total this column up, so I can see total duration in minutes and seconds

However when I do a sumation , it doesn't total in minutes and seconds

I have tried changing the format of the cells to mm:ss however this converts the cell e.g. the value 10:44 is converted to 44:00

I think excel is autoformating this column as hh:mm instead of mm:ss causing the issue.

any ideas?

 

[gsbelbin]

If Excel thinks they are hh:mm then you could just divide them all by 60 and format as mm:ss. You could use the divide function in paste special to do this. If you need an explanation let me know.

 

[scottylad2]

As the last poster says, format your result hh:mm:ss to ensure your results right

Excel Workbook
	G
4	10:44
5	03:57
6	00:00
7	02:38
8	01:11
9	00:50
10	02:34
11	03:36
12	02:50
13	03:26
14	01:00
15	00:32:46
Sheet1