Show Date on Timer and Change Formatting when Approaching Deadlines

[yuusei]

Hi guys,

I'm fairly new to macros and coding, but I want to do some stuff to simplify our work tracker.

I want to set a running timer, which I will use to track deadlines. I copied the code below online, but it's not showing the date properly. Changing the formatting shows the date as 01/01/1900. Is there a way to show the date today on this?

Please Login or Register  to view this content.

For the next issue, I want to compare the value on the timer with the set deadlines. I want that with a click of the button, rows that are an hour before the deadline will change to orange. then set the format to red if they are over the deadline. Can anyone suggest a code for this?

Thanks in advance for your help.

[Logit]

.
.
This will correct the timer issue:

Please Login or Register  to view this content.

[yuusei]

Hi Logit! Thanks! Works wonders and solved the first part of the problem. Just need to set up the conditional statement that will compare time and dates for deadline tracking.

[Logit]

You are welcome.

Glad to help.

[Tsjallie]

Attached example displays the correct format and colors the rows orange when within 1 hour before deadline and red when after deadline.