calendar aggregate with google app script

calendar-aggregate.ts

const calenderId = 'xxxxxxxxxxx@group.calendar.google.com';

function aggregateCalender() {
  const calender = CalendarApp.getCalendarById(calenderId);
  Logger.log(`対象カレンダー: ${calender.getName()}`);

  const startTime = new Date('2021/6/1 00:00:00');
  const endTime = new Date('2021/6/30 00:00:00');
  const events = calender.getEvents(startTime, endTime);
  Logger.log(`イベント件数: ${events.length}`);

  if (events.length < 1) {
    Logger.log('イベントがありません。スクリプトを停止しました');
  }

  const aggregated = events
    .map((e) => calculateActivityTime(e))
    .reduce((prev, curr) => prev + curr, 0);
  Logger.log(`合計時間(h): ${aggregated}`);
}

function calculateActivityTime(event: GoogleAppsScript.Calendar.CalendarEvent) {
  const end = event.getEndTime();
  const start = event.getStartTime();

  // @ts-ignore
  return (end - start) / 1000 / 60 / 60
}