Task timer in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1387931%22%20slang%3D%22en-US%22%3ETask%20timer%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1387931%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%20I%20wanted%20to%20know%20if%20there%20was%20any%20method%20in%20creating%20a%20%22task%20timer%22%20in%20excel%20like%20the%20one%20in%20the%20attached%20link.%20I%20also%20wanted%20to%20know%20if%20there%20was%20any%20feasible%20way%20to%20have%20the%20task%20change%20colors%20depending%20on%20the%20duration%20of%20time%20remaining.%20I.e.%2030%20mins%20yellow%2C%2010%20mins%20orange%2C%205%20mins%20red%2C%20and%20overdue%20black%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1387931%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1387943%22%20slang%3D%22en-US%22%3ERe%3A%20Task%20timer%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1387943%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F667109%22%20target%3D%22_blank%22%3E%40namename%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethere%20was%20no%20attachment%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1387958%22%20slang%3D%22en-US%22%3ERe%3A%20Task%20timer%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1387958%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F622486%22%20target%3D%22_blank%22%3E%40wumolad%3C%2FA%3E%26nbsp%3BThanks!%20It%20should%20be%20in%20there%20now%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello,  I wanted to know if there was any method in creating a "task timer" in excel like the one in the attached link. I also wanted to know if there was any feasible way to have the task change colors depending on the duration of time remaining. I.e. 30 mins yellow, 10 mins orange, 5 mins red, and overdue black?

 

Thank you

2 Replies
Highlighted

Hi @namename 

 

there was no attachment

 

Highlighted

@wumolad Thanks! It should be in there now