Google Apps Script, Excel and more

onEdit Function for Google Sheet

var sheetName = "Sheet1"
function onEdit() {
  var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);
  var activeCell = ss.getActiveCell();
  var row = activeCell.getRow();
  var col = activeCell.getColumn();

  var timeStamp = ss.getRange(row,col-1).getValue();
  var rowHeader = ss.getRange(3,col).getValue();

  if(!activeCell.isBlank() && timeStamp == "" && rowHeader == "COMPLETED" && row > 3){
    ss.getRange(row, col-1).setValue(new Date());
  }
}

Result

Excel Code : Editing for specific time period

    
this code for Workbook_Open
    Private Sub Workbook_Open()
    Call testTime
    End Sub

    
this code for Module
Sub macro_timer()

'Tells Excel when to next run the macro.
Application.OnTime Now + TimeValue("00:00:01"), "testTime"

End Sub
Sub testTime()

Dim datntime As String
Dim timee() As String

datntime = Now

timee = Split(datntime, " ")

If timee(1) > "10:00:00" And timee(1) < "11:00:00" Then
Application.ActiveWorkbook.Activate

Else

MsgBox ("you can edit this sheet only from 10 am to 11 am.")
Application.ActiveWorkbook.Save
Application.Quit

End If
Call macro_timer
End Sub