Consulting

Results 1 to 3 of 3

Thread: PPT Progress Bar based on Time not # of Slides

  1. #1

    PPT Progress Bar based on Time not # of Slides

    I have been searching for code for a PPT progress bar (that slowly changes color) that shows up on every PPT slide that tracks the time since the presentation started to 25 minutes. I can find lots of code based on the number of slides but not based on a predetermined amount of time.

    Can anyone assist?

    Thx - Ray

  2. #2
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    That is because no one can tell how long any given slide will be shown.

    If you can determine that. . .


    Private Function PerCentComplete() as Double
    Const Duration as Double = ??? 'How long the slide show lasts (in decimal days)
    Static StartTime as Double
    
    If StartTime = 0 then StartTime = Now
    
    PerCentComplete = (Now - StartTime) / Duration
    End Function
    Easy way to determine decimal days from a time.

    Format Cell "B1" as a Number with 11 decimal places. Put the formula "=A1" in Cell "B1"
    Put the Time in Cell "A1" in the format "hh:mm:ss"
    Read the Decimal Days in cell "B1"
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  3. #3
    VBAX Regular
    Joined
    May 2011
    Posts
    21
    Location
    Not sure if this helps, but there is a timer when you use the slide show>> rehearse timing mode.
    See the Slide Show section of the ribbon

Posting Permissions

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