I have created a timer in excel. I would like it to beep every second under ten seconds. I have tried the follow method but the beep is happening every second instead of only playing under ten seconds.
Function BeepMe() As String
BeepMe = ""
In Sheet2 Cell B2 I have my timer 12:01:30 AM formatted to display mm:ss
in cell c2 I have this function =IF(B2<"12:00:10",BeepMe()."")
Please advise how to only play the beep under 10 seconds.