Spreedsheet+Site.Google

[ijpbs]

Thanks for the reply and new solution.
Can you share a code to reset to zero '0' for cell B2 automatically after 5 minus.

below code is not working for me

function myFunction() {
  var sheet = SpreadsheetApp.getActive().getSheetByName('sheet1'); sheet.getRange('B2').setValue(0);
}
function createTimeDrivenTriggers() {
  ScriptApp.newTrigger('myFunction')
      .timeBased()
      .everyMinutes(5) //I can not write 0.01 instead of 1 here. 
      .create();
}