Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

counting h:mm:ss in excel

Posted on 2014-03-10
5
Medium Priority
?
195 Views
Last Modified: 2014-03-10
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
Comment
Question by:vthunder70
  • 2
  • 2
5 Comments
 
LVL 53

Expert Comment

by:Rgonzo1971
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

by:
Santosh Gupta earned 1000 total points
ID: 39917668
Hi,

use below formula

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

Author Comment

by:vthunder70
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 53

Assisted Solution

by:Rgonzo1971
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

by:vthunder70
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
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‚Ķ

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question