hello guys. I’m looking for a way to make a spreadsheet with scheduling my daily tasks, studies etc. I would like to specify start and end time for each activity and have it all in a calendar view. It is very important to me that I have a monthly summary with the tasks performed in the month and sum of the number of hours that were used in the month, piling up for each activity.
I need help to do this.
I have the following information:
- start date / time
- end date / time
- number of hours - this column is a formula = end time - start time
- task identification
start ; end ; duration; task identification
8/202020 8:30 am; 08/20/20 10:30 am; 2:00; Study Airtable
2020/08/25 14:00; 2020/08/25 17:00; 3:00; Practicing piano
2020/08/27 8:00; 2020/08/25 10:00; 2:00; Study Airtable
2020/08/28 9:00; 8/202020 11:30 AM; 2:30; Practicing piano
The monthly summary would be as follows:
task identification; total duration
Study Airtable; 4:00
Practice Piano; 5:30
Thanks in advance.