Countdown Clock

  toastieonline 17:31 27 Sep 2003

I would like to project a countdown clock from my computer. Does anyone know of any software which may be able to do this?
Many thanks.

  Kitz E Kat 18:17 27 Sep 2003

if im a bit stupid, you want to do what???

Kitz E

  froggg 18:27 27 Sep 2003

ask micro-direct,they use one for offers

  VoG II 00:17 28 Sep 2003

Do you have Excel?

Project onto what?

Countdown from what?

If we can understand what you want to do it will help.

  powerless 00:49 28 Sep 2003


  toastieonline 13:40 28 Sep 2003

its to run through a video projector onto a big screen to notify people of the time remaining before a presentation will begin. sorry if i did not make it clear.
any suggestions would be most appreciated?

  VoG II 13:50 28 Sep 2003

Well you can do it in Excel using a macro:

Dim AlarmTime As Date, AlarmTime2 As Date

Sub Count_Down_Timer()

ActiveSheet.Range("A1").Value = 60

ActiveSheet.Range("B1").Value = "Counting"

Call TrapTime

Call TrapTime2

End Sub

Private Sub ShowTimeLeft()

ActiveSheet.Range("A1").Value = Second(AlarmTime - Now)

Call TrapTime2

End Sub

Private Sub TrapTime()

AlarmTime = CDate(Date) + TimeValue(Now()) + TimeValue("00:01:00")

Application.OnTime earliesttime:=AlarmTime, procedure:="StopTimer"

End Sub

Private Sub TrapTime2()

AlarmTime2 = CDate(Date) + TimeValue(Now()) + TimeValue("00:00:01")

Application.OnTime earliesttime:=AlarmTime2, procedure:="ShowTimeLeft"

End Sub

Private Sub StopTimer()

On Error Resume Next

Application.OnTime earliesttime:=AlarmTime2, procedure:="showtimeleft", schedule:=False

On Error GoTo 0

ActiveSheet.Range("B1").Value = "Done"
End Sub

You would need to copy the above code, Start Excel, ALT+F11 to open the Visual Basic Editor. Insert/Module and paste in the code. Close the Visual Basic Editor.

Tools/Macro/Macros, select Count_Down_Timer and click Run.

You could adapt the code to suit.

It may be possible to do something similar in Powerpoint but I'm not sure.

  Chris the Ancient 14:00 28 Sep 2003

I tried a PowerPoint one, some years ago, with no success. In the end, I used a sysytem very similar to yours - with a slight addition! It was a meeting costs display. At the start of the meeting, you put in how many people of different categories (and their hourly rates) were there, clicked on the start button - and off it went. You could see the old pounds clicking up quite rapidly, and after the novelty wore off, the meetings were a lot quicker. The boss made sure of that!

  VoG II 14:04 28 Sep 2003

What an excellent idea! I'm going to make use of that.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?