Forum Discussion
Count Down Timer showing Days, hours, minutes and seconds
I am attempting to create a spreadsheet to track my employment history with my current company. I would like to include a cell that shows a live countdown for the number of days, hours, minutes and s...
Jonathan,
you can only show max 31 days with format dd:hh:mm:ss because Excel really doesn't display the number of days but the day in the month (since 00.01.1900). 31 means 31.01.1900. After 31 (31.01.1900) comes 01 (01.02.1900) and after 60 (29.02.1900) comes 01 (01.03.1900) again and so on.