How to calculate elapsed time? (stopwatch / timer / timestamps)

[Blark]

I want to be able to take live notes during a video recording, and then be able to go back into the recording and find things easily.

More specifically, imagine a user:

1. Opens empty table

2. Types text into record 1, time is noted in adjacent cell as 00:00 (mm:ss)
   [it takes them 5 seconds to do this]

3. Types text into record 2, time is noted in adjacent cell as 00:05 (mm:ss)
   [it takes them 15 seconds to do this]

4. Types text into record 3, time is noted in adjacent cell as 00:20 (mm:ss)

And so on…

[Blark]

Thank you for the reply. The issue I’m experiencing is that the Timestamp field starts with seconds from the system time, not 0. This throws the timestamp off by however many seconds after 0 the current system time is.

[ScottWorld]

Oh, that’s interesting. This highlights even more the problems between the user-controlled date fields where we can’t control seconds vs. Airtable’s built-in date fields that do have access to seconds. I think you’ll probably need to compensate for that difference in your formulas.