STEVE CHASE' COUNTDOWN TIMER
1. Type the labels in A1 through A4
A1 = Date and Time today
A2 = Hour
A3 = Minute
A4 = Second
2. Enter the formulas in column B
B1 =NOW()
B2 =HOUR(B1)
B3 =MINUTE(B1)
B4 =SECOND(B1)
*Note: The NOW function displays the current date and time. Pressing F9 key will update the value.
The HOUR function displays the current hour expressed in Military Time; Zero is 12:00 AM and 23 is 11:00PM
3. Type these labels in D1 though D4
D1 = Event Date
D2 = Event Hour
D3 = Event Minute
D4 = Event Second
4. Type in the datails of the Event Schedule in cells E1 through E4
5. Type these labels in cells G1 through G4
G1 = Days
G2 = Hours
G3 = Minutes
G4 = Seconds
6. Type in the FORMULAS in H1 through H4
H1 =INT(E1-B1)
H2 =IF(E2>=B2,E2-B2,24-B2+E2)
H3 =INT(E3-B3)
H4 =INT(E4-B4)
7. Make the Display by using this function
="Just"&H1&"Days"&H2&"Hours"&H3&"Minutes"&H4&"Seconds Left"
