Blark - profile

Blark · May 25, 2020

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: Opens empty table Types text into record 1, time is noted in adjacent cell as ...

Blark · May 25, 2020

It would appear that the ‘Date’ field does not record seconds.Here’s why I think this:Here are the formulas I’m using to expose this:DATETIME_FORMAT({Date (no secs?)}, ‘DD-MM-YYYY h:mm:ss’)DATETIME_FORMAT({Created Time}, ‘DD-MM-YYYY h:mm:ss’)I hope I...

Blark · May 25, 2020

It would appear that the ‘Date’ field does not record seconds. Here’s why I think this: Here are the formulas I’m using to expose this: DATETIME_FORMAT({Date (no secs?)}, ‘DD-MM-YYYY h:mm:ss’) DATETIME_FORMAT({Created Time}, ‘DD-MM-YYYY h:mm:ss’) I ...

Blark · May 27, 2020

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.

Blark · May 26, 2020

That is an awesome trick, and it works! Now the issue is that the first record creates a timestamp of the actual clock time, not :00. Here’s the formula I’m using: DATETIME_DIFF(LAST_MODIFIED_TIME(),{Actual Start Time},‘seconds’) I made a video of th...

Blark · May 26, 2020

@ScottWorld, I tried it out, and it works! Thanks! @kuovonne Now I need to figure out a way to make it less manual as you mentioned. Currently I have to copy the Actual_Start_Time to each record one by one, otherwise they all get the same timestamp. ...

Blark · May 25, 2020

Thanks @kuovonne and @ScottWorld – those are great solutions. I’ll probably just calculate the elapsed time. So simple! I just wish the ‘Date’ field recorded seconds – that’s what I was trying to use as my “Actual_Start_Time.”

Blark · May 25, 2020

Thanks @ScottWorld: I added this to Product Suggestions, per your suggestion: Support seconds in Date field

User Statistics

User Activity

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

Support seconds in Date field

Does 'Date' field not record seconds?

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

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

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

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

Re: Does 'Date' field not record seconds?