I have assigned the functions to the pictures. But I don’t understand why the function always takes the last else. Could someone help me?
Thank you very much!
var mondayClearAb = timeStamp.getRange(7, 2);
var tuesdayClearAb = timeStamp.getRange(8, 2);
var wednesdayClearAb = timeStamp.getRange(9, 2);
var thursdayClearAb = timeStamp.getRange(10, 2);
var fridayClearAb = timeStamp.getRange(11, 2);
var saturdayClearAb = timeStamp.getRange(12, 2);
var sundayClearAb = timeStamp.getRange(13, 2);
var mondayClearAe = timeStamp.getRange(7, 3);
var tuesdayClearAe = timeStamp.getRange(8, 3);
var wednesdayClearAe = timeStamp.getRange(9, 3);
var thursdayClearAe = timeStamp.getRange(10, 3);
var fridayClearAe = timeStamp.getRange(11, 3);
var saturdayClearAe = timeStamp.getRange(12, 3);
var sundayClearAe = timeStamp.getRange(13, 3);
function currentDay () {
var newTime = new Date();
var numberOfDay = newTime.getDay();
}
function addZero(i) {
if (i < 10) {
i = "0" + i;
}
return i;
}
function startTime () {
var timeStamp = SpreadsheetApp.getActiveSheet();
var time = new Date();
var hours = addZero(time.getHours());
var minutes = addZero(time.getMinutes());
var seconds = addZero(time.getSeconds());
if (currentDay == 1 && mondayClearAb.isBlank()) {
timeStamp.getRange(7, 2).setValue(hours + ":" + minutes + ":" + seconds);
}
else if (currentDay == 2 && tuesdayClearAb.isBlank()) {
timeStamp.getRange(8, 2).setValue(hours + ":" + minutes + ":" + seconds);
}
else if (currentDay == 3 && wednesdayClearAb.isBlank()) {
timeStamp.getRange(9, 2).setValue(hours + ":" + minutes + ":" + seconds);
}
else if (currentDay == 4 && thursdayClearAb.isBlank()) {
timeStamp.getRange(10, 2).setValue(hours + ":" + minutes + ":" + seconds);
}
else if (currentDay == 5 && fridayClearAb.isBlank()) {
timeStamp.getRange(11, 2).setValue(hours + ":" + minutes + ":" + seconds);
}
else if (currentDay == 6 && saturdayClearAb.isBlank()) {
timeStamp.getRange(12, 2).setValue(hours + ":" + minutes + ":" + seconds);
}
else {
timeStamp.getRange(13, 2).setValue("Frei");
}
}
function endTime () {
var timeStamp = SpreadsheetApp.getActiveSheet();
var time = new Date();
var hours = addZero(time.getHours());
var minutes = addZero(time.getMinutes());
var seconds = addZero(time.getSeconds());
if (currentDay == 1 && mondayClearAe.isBlank()) {
timeStamp.getRange(7, 3).setValue(hours + ":" + minutes + ":" + seconds);
}
else if (currentDay == 2 && tuesdayClearAe.isBlank()) {
timeStamp.getRange(8, 3).setValue(hours + ":" + minutes + ":" + seconds);
}
else if (currentDay == 3 && wednesdayClearAe.isBlank()) {
timeStamp.getRange(9, 3).setValue(hours + ":" + minutes + ":" + seconds);
}
else if (currentDay == 4 && thursdayClearAe.isBlank()) {
timeStamp.getRange(10, 3).setValue(hours + ":" + minutes + ":" + seconds);
}
else if (currentDay == 5 && fridayClearAe.isBlank()) {
timeStamp.getRange(11, 3).setValue(hours + ":" + minutes + ":" + seconds);
}
else if (currentDay == 6 && saturdayClearAe.isBlank()) {
timeStamp.getRange(12, 3).setValue(hours + ":" + minutes + ":" + seconds);
}
else {
timeStamp.getRange(13, 3).setValue("Frei");
}
}