我想将一系列值格式化为一行代码。
var C1GD29 = Utilities.formatDate(ReportSheet.getRange('D29').getvalue(),ss.getSpreadsheetTimeZone(),"HH:MM");
var C1GD30 = Utilities.formatDate(ReportSheet.getRange('D30').getvalue(),"HH:MM");
var C1GD31 = Utilities.formatDate(ReportSheet.getRange('D31').getvalue(),"HH:MM");
var C1GD32 = Utilities.formatDate(ReportSheet.getRange('D32').getvalue(),"HH:MM");
var C1GD33 = Utilities.formatDate(ReportSheet.getRange('D33').getvalue(),"HH:MM");
var C1GD34 = Utilities.formatDate(ReportSheet.getRange('D34').getvalue(),"HH:MM");
var C1GD35 = Utilities.formatDate(ReportSheet.getRange('D35').getvalue(),"HH:MM");
var C1GD36 = Utilities.formatDate(ReportSheet.getRange('D36').getvalue(),"HH:MM");
var C1GD37 = Utilities.formatDate(ReportSheet.getRange('D37').getvalue(),"HH:MM");
var C1GD38 = Utilities.formatDate(ReportSheet.getRange('D38').getvalue(),"HH:MM");
var C1GD39 = Utilities.formatDate(ReportSheet.getRange('D39').getvalue(),"HH:MM");
var C1GD40 = Utilities.formatDate(ReportSheet.getRange('D40').getvalue(),"HH:MM");
我在下面尝试过此操作,但出现错误。
var TimeLog = Utilities.formatDate(ReportSheet.getRange('D29:D40').getvalues(),"HH:MM");
有人可以告诉我正确的书写方式吗?