Countdown Clock

  toastieonline 17:31 27 Sep 03

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 03

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

Kitz E

  froggg 18:27 27 Sep 03

ask micro-direct,they use one for offers

  VoG II 00:17 28 Sep 03

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 03


  toastieonline 13:40 28 Sep 03

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 03

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 03

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 03

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

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

Hands-on: Acer Predator Triton 700 review

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

How to lose weight with an Apple Watch