Instructions: Do enable the Macro for an automated countdown to a target date/time. Or you can click/hold down "F9" to see a constantly updating countdown, if you do not want to enable the Macro. Enter the Target date and time in the yellow cell(s) below Target Future Time Time remaining:
Countdown to a FUTURE time
Add any target date and time in the next cell below, in the same format you see h 5/9/10 17:00 (DD-MM-YY HH:MM)
367 days 17 hrs 43 min and 38 sec
Countdown from a PAST time
Target Past Time Time passed:
Add any target date and time in the next cell below, in the same format you see h 17/5/09 22:00 (DD-MM-YY HH:MM)
108 days 1 hrs 16 min and 21 sec ago
able the Macro.
n the same format you see here.
and 38 sec
n the same format you see here.
nd 21 sec ago
Here's the explaination of how one can use Excel to do a countdown to a specific day and time.
Countdown to a FUTURE time
Cells formatted as date & time Cells formatted as number Computer time NOW Future date/time Difference 9/2/09 11:16 PM 9/5/20 12:00 PM 1/2/11 12:43 PM 40058.96969155 44079.50000000 4020.53030845 That means the future date will be reached in Hours Min. Days 12 44 4020 4020 days, 12 hours, 43 minutes, and 38 seconds.
"CONCATENATE" combines texts together
Countdown from a PAST time
Cells formatted as date & time Cells formatted as number Past date/time Computer time NOW Difference 4/17/03 4:30 PM 9/2/09 11:16 PM 5/18/06 6:46 AM 37728.68750000 40058.96969155 2330.28219155 That means the past date has been over for Hours Min. Days 6 46 2330 2330 days, 6 hours, 46 minutes, and 21 seconds ago.
"CONCATENATE" combines texts together
be reached in Sec 38
een over for Sec 21
Countdown to a FUTURE time (v2)
Hour Minute Second Enter the time today in 24-hour format 18 5 1 *This time must be AFTER the current time. Do enable the Macro for an automated countdown to a target date/time. Or you can click/hold down "F9" to see a constantly updating countdown, if you do not want to enable the Macro. Time Remaining:
#NAME?
(hour:min:sec)
Equivalent time:
6:05 PM
o not want to enable the Macro.