Solved

# counting h:mm:ss in excel

Posted on 2014-03-10
177 Views
Hi guys,
I'm trying to document some video times. There are thousands of them!
I set up an excel sheet with the times in this format:

hh:mm:ss

I just need the total time of all videos in minutes and second format so:

mm:ss

Excel is givine me a weird number when I do SUM=(c1,c320) and I format the cell to time.
0
Question by:vthunder70
• 2
• 2

LVL 48

Expert Comment

ID: 39917631
HI,

If you want the minutes

You have to format like this [mm]:ss ( In custom format)

Regards

EDITEE20140310.xlsx
0

LVL 13

Accepted Solution

Santosh Gupta earned 250 total points
ID: 39917668
Hi,

use below formula

=TEXT(SUM(c1:c320), "[mm]:ss")
0

Author Comment

ID: 39917693
I though I posted a file with example data.

Take a look at the attached file, it has 231 times but the total at the top only says 23:42

There is way more than 23 minutes worth of video there.
experts.xlsx
0

LVL 48

Assisted Solution

Rgonzo1971 earned 250 total points
ID: 39917711
Hi,

First the formula should be

=SUM(A1:A231) not =SUM(A1;A231)

then apply the format [h]:mm:ss or [mm]:ss as you like

Regards
0

Author Closing Comment

ID: 39917737
I think splitting the points evenly is the way to go here since one gave me the exact formula I was looking for and the other fixed my bug :)

Thanks guys!
0

## Featured Post

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.