Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Slide Timings in Excel

    I am using Excel as a database to track slide timings for instructional videos I produce. They are narrated PowerPoint slides and I record the start time and end time and have Excel calculate the duration. This works perfectly as long as the videos are shorter than 24 minutes long. That is because I enter the times like this

    Image.jpg

    Excel ends up converting the mm:ss start/end times into times so 00:03 becomes 12:03:00 AM. A start or end time above 24 minutes does not work because there are only 24 hours in the day so 25:13, for example, gets converted to 1/1/1900 1:13:00 AM. Is there a way to work with these timings when they exceed 24 minutes?


    Ronny
    Ronny Richardson

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,468
    Thanks
    30
    Thanked 61 Times in 57 Posts
    I entered the start and end times as you did, and had the custom format for the difference set to h:mm and I think that gives you what you want.



    Kevin
    Attached Images Attached Images
    Last edited by kweaver; 2013-04-16 at 12:30.

  3. The Following User Says Thank You to kweaver For This Useful Post:

    Ronny (2013-04-26)

  4. #3
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    1. Format the cells with the custom format mm:ss

    2. Enter your timings as follows:
    For the start time 00:00:00
    For 3 seconds 00:00:03
    For your last start 00:02.54
    etc

    That should work, and will allow you to perform any subtractions and display the correct results.

    If your presentations are really long (mind-numbingly long !) you could use the format hh:mm:ss if you like.

  5. #4
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post
    That works great, thanks.

    Ronny
    Ronny Richardson

  6. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    h:mm gives hours and minutes in a day so after 24 hours it is a new day with the "wrapped time". If you want elapsed hours use:
    [h]:mm

    For elapesed minutes (minutes over 59) use:
    [m]:ss

    Steve

  7. #6
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post
    That is good to know. I will try it on Monday.


    Ronny
    Ronny Richardson

Posting Permissions

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