Start Macro if Timer Less Than 10 Minutes

[andybason]

Hello

I have a sheet that contains a countdown timer in D2 (in hh:mm:ss format) that is populated by external software. The sheet also has a change event macro that runs when E2 contains something:

If ThisWorkbook.Worksheets("Attendance").Range("E2") <> ""

Is it possible to add a condition that the macro only runs when the timer is also less than 10 minutes to go?

Thank you

 

[John_w]

Try this:

    With ThisWorkbook.Worksheets("Attendance")
        If .Range("E2").Value <> "" And .Range("D2").Value < TimeValue("00:10:00") Then
        
        End If
    End With

 

[andybason]

Hello John, this works perfectly. Thank you

 

[andybason]

Actually, I just noticed that when the timer reaches negative time values the macro stops running. Often it will go below 00:00:00. Is there a way of allowing the macro to continue in these circumstances? Thanks