Create a weekly calculation spreadsheet
jean-george
Posted messages
3
Status
Membre
-
jeanochev Posted messages 123 Registration date Status Membre Last intervention -
jeanochev Posted messages 123 Registration date Status Membre Last intervention -
Hello,
I am currently learning how to use OpenOffice Calc in order to create (mainly) a timesheet workbook.
Basically, I have created several columns: date; arrival time; break; return; end; total day; total week.
Each row corresponds to a day of the week.
I can automatically calculate the daily total.
However, I can't figure out how to automatically calculate the weekly total. I have to do it manually for each group of 7 days.
Is there a way to make my total week column understand that it should add itself up every Monday to Sunday?
And as an aside, is there a way to remove Saturdays and Sundays from my date column, since I created it automatically as well? (At worst, I'll fill it in manually, but if I could avoid that, it would be great.)
Thanks in advance.
Configuration: Windows 7 / Chrome 39.0.2171.71
I am currently learning how to use OpenOffice Calc in order to create (mainly) a timesheet workbook.
Basically, I have created several columns: date; arrival time; break; return; end; total day; total week.
Each row corresponds to a day of the week.
I can automatically calculate the daily total.
However, I can't figure out how to automatically calculate the weekly total. I have to do it manually for each group of 7 days.
Is there a way to make my total week column understand that it should add itself up every Monday to Sunday?
And as an aside, is there a way to remove Saturdays and Sundays from my date column, since I created it automatically as well? (At worst, I'll fill it in manually, but if I could avoid that, it would be great.)
Thanks in advance.
Configuration: Windows 7 / Chrome 39.0.2171.71
