Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
Solved

# counting h:mm:ss in excel

Posted on 2014-03-10
Medium Priority
196 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 54

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 1000 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 54

Assisted Solution

Rgonzo1971 earned 1000 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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an article on how to answer questions, earn points and become an expert.
Lost Word File? Eagerly, need it back? Read ahead; this File Recovery guide is for you.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
###### Suggested Courses
Course of the Month10 days, 6 hours left to enroll