Jan 26, 202402:27 AM - edited Jan 26, 202402:35 AM
I've been trying to achieve the following for a few hours now, but without any luck.
STEP 1: I track the time I spend on a certain activity (# session in minutes column in screenshot)
STEP2: I also sum up the time I spent across all sessions (# sum minutes column in screenshot)
Question: Right now I have to do step 2 manually. As you can see in the screenshot, I manually add the last session's number of minutes to the existing sum of minutes. I oftentimes forget, and / or make errors.
How can I do STEP2 automatically? I just want a column in which the last sessions' number of minutes gets automatically added to the existing total sum of minutes.
Do you have ANY idea on how to do this? Seems kind of simple and I'd know how to to this in excel but I can't seem to get this to work in Airtable.