Surely this is an easy formula, but I just can’t get my brain to bend this way:
I am using Airtable for my timesheet for my employees. I would like to improve upon my existing “Total Hours” formula by showing “Total Hours by task” , and each task is a single select item in another field.
Here’s my “Total Hours” formula currently:
DATETIME_DIFF({Time Out},{Time In},‘minutes’) / 60
Field for the different tasks is aptly named: “Task”
Specific Single Select is “Teaching”
Please help! Thanks!