This should wake you up at 16:30 PM
----------------------------------------
Sub Reminder()
If Time = TimeSerial(16, 30, 0) Then
MsgBox "Wake Up! The time is: " & Time
Exit Sub
End If
Application.OnTime (Now + TimeSerial(0, 0, 1)), "Reminder"
End Sub