+ Reply to Thread
Results 1 to 5 of 5

Time Formats

  1. #1
    Registered User
    Join Date
    12-24-2008
    Location
    Jackson, Wisconsin
    Posts
    22

    Question Time Formats

    I'm building an excel spreadsheet for my movie collection. I've gotten to the point where the total runtime of my entire collection, right now, stands at about 43 days (over 1,030 hours). I can have excel format the cell to indicate dd:hh:mm:ss, but if mm is minutes, what can I use for months? Obviously, formatting the cell as mm:dd:hh:mm:ss messes it all up, because it's inputting the minutes twice.

    If this is not an option, what would be my best course of action to get a precise total runtime, down to the second?
    Last edited by cmcasper; 11-28-2012 at 12:05 PM.

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Time Formats

    Why bother with months? Months are not precise; months contain a variable number of days.
    Gary's Student

  3. #3
    Registered User
    Join Date
    12-24-2008
    Location
    Jackson, Wisconsin
    Posts
    22

    Re: Time Formats

    Excellent point. I guess I'll just stick with hh:mm:ss.

  4. #4
    Registered User
    Join Date
    12-24-2008
    Location
    Jackson, Wisconsin
    Posts
    22

    Re: Time Formats

    Is there any way to work a comma into the format for the "hh" part?

  5. #5
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Time Formats

    Yes. use this Custom Format:

    d, hh:mm:ss

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1