Countdown clock in Excel
Informatics, Uncategorized | (11)
My work buddy Jurre is drastically changing his career path for the better by relocating to Ireland this week. To help him keep track of the time he has left in his current job I made him a countdown clock in Excel. It shows the number of days, hours, minutes and seconds left both in separate cellsĀ of a sheet and in the titlebar of the Excel window. It demonstrates the use of the scarcely documented Excel function DATEDIF and the Application.OnTimeĀ method to update the clock at one second intervals. The workbook you can download here counts down to the new ...