Hello,
This table register the time my employes arrive ("Entrata") and leave ("Uscita") using an Airtable database.
I managed to have a number that defines the total of hours my employes work during the day using DATETIME_PARSE in the "Worked Hour" Column. I need to sum those hours together in "Total Month" Column (first of all) and then make sure it does consider the month.
I'll explain myself better, i would like something like this, using this image.
At the end of the formula, i would like to SUM Worked Hours from Line 1 and Worked Hours from line 2, and show it in "Total Month" of the latest created row.
As second step, If a new row is created, it checks if the current month in "Created" (i can do it with PARSE i think) is the same month of the row below:
- If it's the same month, it automatically adds the value of the total hours in "Total Month"
- If it's not, it sets the counting of "Total Hours" to 0 and then it adds the Worked Hour of the day
My question is, is it possible to sum those numbers together ad show them in a cell next to it?
My main problem is gathering data from other cells.
Thank you very much for your help.
