![]() |
#1
|
|||
|
|||
![]()
Hi guys,
after having spent almost 4 nights without getting hardly one single step forward, I finally had to admit that I would have to reach out to the pros. ![]() What I want to do is the following:
Let’s have an example.
Assuming that my presentation is scheduled to start at 09:00 (StartingTime = 09:00) and that it starts on time and the first two sections took as scheduled 15 minutes together, then the textboxes on slide 17 when starting section 3 should indicate: OverallTime = 15 minutes and Delay = 0 (Current time – (StartingTime + ChapterDuration[seciton1] + ChapterDuration[section2]) However, if the presentation actually started at 09:04 and the first section took say 3 minutes longer, than scheduled, the textbox Delay on slide 17 should display 7 minutes because the current time is now 09:22 and 09:22 – (09:00 + 5 minutes + 10 minutes) = 7 minutes. The three major problems I encounter are:
Thanks for your appreciated help. Michael |
Tags |
calculation, vba |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sending e-mail with delay | paik1002 | Outlook | 1 | 02-29-2016 11:27 AM |
Auto run macro with delay | bremen22 | Excel Programming | 0 | 02-04-2016 06:53 AM |
![]() |
ketanco | Project | 3 | 03-15-2013 01:06 PM |
![]() |
Foxfire | Mail Merge | 5 | 08-20-2011 02:40 AM |
![]() |
Registrar | Outlook | 1 | 07-01-2010 10:17 AM |