PPT Progress Bar based on Time not # of Slides

[The Dutchman]

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

[SamT]

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"

[mooseman]

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