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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Hands-on with the Star Wars fighting drones you can fly yourself

15 macOS Sierra tips | How to use macOS Sierra: Secret tricks and best new features in Apple's new…