title: Time based Google Script - Trigger between 12:00am to 12:30am every minute
body: <p>I have a script to copy data from one google sheet to another, the code is this:</p>
  
  <pre><code>function copy() {
   var sss = SpreadsheetApp.openById('ID'); //replace with source ID
   var ss = sss.getSheetByName('Cap'); //replace with source Sheet tab name
   var range = ss.getRange('A:F'); //assign the range you want to copy
   var data = range.getValues();
  
   var tss = SpreadsheetApp.openById('ID'); //replace with destination ID
   var ts = tss.getSheetByName('Cap'); //replace with destination Sheet tab name
   ts.getRange(1, 1, data.length, data[0].length).setValues(data);
  }
  </code></pre>
  
  <p>I need to run this script everyday at 12:00am, and until 12:30am run it every minute, I don't need it to run anymore on the day</p>
  
  <p>I can set triggers like daytime (to run between 12 and 1 am) or hour time (every hour) but thats not what I need, thats not accurate, I just need to run exactly at 12:00am and so on as explained for 30 minutes every minute</p>
  
  <p>and if I set the trigger to run every minute I get "Service using too much computer time for one day"</p>
  
  <p>Is there a way to set this on the script trigger ?</p>
  
  <p>Thanks !</p>