md982jdib2d

function checkIfNewRow() {

 var ss = SpreadsheetApp.getActiveSpreadsheet();
 var sheetLatest = ss.getSheets()[2];
 var sheetNew = ss.getSheets()[0];
 var latestNew = sheetNew.getRange(sheetNew.getLastRow(), 1).getValue(); // date
 var lastestProcessed = sheetLatest.getRange(sheetLatest.getLastRow(), 1).getValue(); // date

  if(latestNew != lastestProcessed) {
    // Process it!!
    addToFinalSheet();

    // Append to latests processed sheet
    sheetLatest.appendRow([latestNew]);

  } else {
    // do nothing, as there is nothing new
  }
}



function addToFinalSheet() {

 var ss = SpreadsheetApp.getActiveSpreadsheet();
 var sheet = ss.getSheets()[0];

 var lastRowInt = sheet.getLastRow();

 var dateTimeStartedSleeping = sheet.getRange(lastRowInt, 1);
 var finalDate = dateTimeStartedSleeping.getValue().replace('at ', ', ');

 var hoursSlept = sheet.getRange(lastRowInt, 2);
 var finalHours = 'for ' + hoursSlept.getValue().replace('h', ' hours').replace('m', ' minutes');
 var sheet2 = ss.getSheets()[1];

 // Appends a new row with 3 columns to the bottom of the
 // spreadsheet containing the values in the array
 sheet2.appendRow([finalDate, finalHours]);

}