Instructions: Enter the Target date and time in the yellow cell(s) below You need to click/hold down "F9" to see a constantly updating countdown.
Enter 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
Enter 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
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.96968970 44079.50000000 4020.53031030 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.96968970 2330.28218970 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