Creating a Clock in Excel with

[Cquake]

Could someone guide me in what steps I need to take to create a sports style countdown clock in excel using the following criteria.

1. Cell A5 for example would show the time left in a quarter ( Every quarter starts at 15:00 )
2. Cell A6 would be for entering an elapsed time to deduct from Cell A5 (After hitting enter it would then clear the box in A6 and also deduct from A5 to update the time left.

This would be repeated continuously until the clock hit 00:00 for each quarter. At the start of each quarter either manually enter that 15:00 to begin a new count down or have a re-set button that would reset it to that 15:00

 

[MrIfOnly]

You're welcome.

CJ

 

[Cquake]

MrIf

Hey just wanted to pass this on to you as the following formula below does work in excel for a 15 minute clock with manual input countdown. When you put in 15:00 in any cell it will show as 3:00:00PM in the bar. Here is the code that would allow for the clock down below. This was shown to me by a friend at work. Those are the last 3 entries but you would do that for each timing sequence you would need to have deducted from the clock. Thanks again so much for all your help but wanted to post this for you in case you ever needed it for yourself in a excel spreadsheet without having to make a clock.

Sub Rectangle16_Click()
'
' Rectangle16_Click Macro
'
' Keyboard Shortcut: Ctrl+Shift+Q
Range("BE6").Value = DateAdd("n", -40, Range("BE6").Value)

'
End Sub
Sub Rectangle17_Click()
'
' Rectangle17_Click Macro
'
' Keyboard Shortcut: Ctrl+Shift+W

Range("BE6").Value = DateAdd("n", -45, Range("BE6").Value)
'
End Sub
Sub Rectangle18_Click()
'
' Rectangle18_Click Macro
'
' Keyboard Shortcut: Ctrl+Shift+E

Range("BE6").Value = DateAdd("n", -45, Range("BE6").Value)
ActiveCell.FormulaR1C1 = "3:00:00 PM"
Range("BE6").Select
'