Help

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

Solved
Jump to Solution
4014 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Blark
5 - Automation Enthusiast
5 - Automation Enthusiast

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…

11 Replies 11
Blark
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

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.