Count Down Timer showing Days, hours, minutes and seconds

%3CLINGO-SUB%20id%3D%22lingo-sub-210464%22%20slang%3D%22en-US%22%3ECount%20Down%20Timer%20showing%20Days%2C%20hours%2C%20minutes%20and%20seconds%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-210464%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20attempting%20to%20create%20a%20spreadsheet%20to%20track%20my%20employment%20history%20with%20my%20current%20company.%20I%20would%20like%20to%20include%20a%20cell%20that%20shows%20a%20live%20countdown%20for%20the%20number%20of%20days%2C%20hours%2C%20minutes%20and%20seconds%20until%20my%20next%20anniversary%20date.%20The%20screenshot%20below%20is%20my%20spreadsheet%2C%20and%20cell%20I10%20is%20my%20counter.%20I%20tried%20formatting%20it%20as%20dd%3Ahh%3Amm%3Ass%2C%20but%20as%20you%20can%20see%2C%20it%20is%20displaying%2097%20days%20(minus%20a%20few%20hours%2C%20minutes%20and%20seconds)%20as%205%20days.%20Is%20there%20a%20way%20to%20correct%20this%20either%20through%20formatting%20or%20possibly%20a%20VBA%20script%20to%20run%20to%20accomplish%20the%20same%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22Capture.JPG%22%20style%3D%22width%3A%20966px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F36829i5787F4FA104A9A86%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Capture.JPG%22%20alt%3D%22Capture.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-210464%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-210480%22%20slang%3D%22en-US%22%3ERe%3A%20Count%20Down%20Timer%20showing%20Days%2C%20hours%2C%20minutes%20and%20seconds%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-210480%22%20slang%3D%22en-US%22%3E%3CP%3EJonathan%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyou%20can%20only%20show%20max%2031%20days%20with%20format%26nbsp%3B%3CSPAN%3Edd%3Ahh%3Amm%3Ass%20because%20Excel%20really%20doesn't%20display%20the%20number%20of%20days%20but%20the%20day%20in%20the%20month%20(since%2000.01.1900).%2031%20means%2031.01.1900.%20After%2031%20(31.01.1900)%20comes%2001%20(01.02.1900)%20and%20after%2060%20(29.02.1900)%20comes%2001%20(01.03.1900)%20again%20and%20so%20on.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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 seconds until my next anniversary date. The screenshot below is my spreadsheet, and cell I10 is my counter. I tried formatting it as dd:hh:mm:ss, but as you can see, it is displaying 97 days (minus a few hours, minutes and seconds) as 5 days. Is there a way to correct this either through formatting or possibly a VBA script to run to accomplish the same?

 

 

Capture.JPG

1 Reply
Highlighted

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.