punchin-bot

Suppose we are hosting a Study Room as Voice Channels in the Discord server.

Punchin Bot helps record how much time a user spends in the Study Room, which is stored in Google Sheets.

Example:

On 2020-11-12, user chloezzzzz joins the Study Room at 14:45 and leaves the Study Room at 15:53.

Google Sheets screenshot:

Features

Record study time

When user joins or leaves the Study Room, timestamp will be inserted for that day in Google Sheets.

Retrieve study time

Example:

$get_my_study_record

Output:

2020-11-12: | 14:45 ~ 15:53

Retrieve study hours

Example:

$get_my_study_hours

Output:

2020-11-12: 1.13