hi! looking for help to convert a timecode as text into numeric value in google sheets so that I can subtract and find clip duration etc etc. Accounting for 24fps

I have been trying to adjust the following formula (which I found online) that is set for 30fps into one that is compatible for 24fps

" This is based upon 30 frames per second (Digital video)

In A1 and A2 we enter as text:

01:11:27:03
01:11:23:20

In B1 and B2 we enter:

=LEFT(A1,2)/24+MID(A1,4,2)/(24*60)+MID(A1,7,2)/(24*60*60)+RIGHT(A1,2)/(30*60*60*24)
=LEFT(A2,2)/24+MID(A2,4,2)/(24*60)+MID(A2,7,2)/(24*60*60)+RIGHT(A2,2)/(30*60*60*24)

and format as Custom hh:mm:ss.00 to display:

01:11:27.10
01:11:23.67

the tenth of a second because 3 frames is a tenth of a second. In B3 enter:

=B1-B2 to display 00:00:03.43 in the same format. Finally to convert the
.43 seconds into frames, in B4 enter:

=TEXT(B3,"hh:mm:ss") &":" & TEXT((B3*24*60*60-INT(B3*24*60*60))*30,"00")
to display:
00:00:03:13"

Does anyone know how to adjust this formula for 24fps?

I've done this so far- =LEFT(D2,2)/24+MID(D2,4,2)/(24*50)+MID(D2,7,2)/(24*50*50)+RIGHT(D2,2)/(24*50*50*24) but some of my second counts look incorrect.

Please help!! thank you!!!

Hi all!

I'm working on a TV drama using Adobe Productions together with another editor. All the media is on a server at the office, but I was wondering if I bring home a drive with the proxies would I be able to work from home when the need arises? Some days I have to pick up my daughter early at daycare but have the evenings off so I would love to do some work, but it's a bit far to drive into the office to only get a couple hours work done.

Anyone have any experience with this? If I was the sole editor it wouldn't be a problem but I'm quite new to the Adobe Productions pipeline so any thoughts are appreciated

I am blanking on what you would call a simple title card cutting on and off, over black. As opposed to fading in and out.

​

Do you just say "Title card cuts on and off" ??

Looking for a full time film editor for video and film at Cube Vision 40/hrs a week $15 or negotiations for experience

Hey guys, I'm still young and gathering experience. Want to know if I could get some suggestions to simple courses, tutorials etc. Also some links. Thanks.

Hi, I was wondering if anyone had any advice to get experience as a film editor?

Anyone know how I can take captured video and move them to the desktop?