Timecode calculator formula not working

Discuss the spreadsheet application
Post Reply
PostCollective
Posts: 1
Joined: Fri Jan 19, 2018 9:31 am

Timecode calculator formula not working

Post by PostCollective »

I need to create a little spreadsheet to log timecode (video) and calculate duration.

I've used this in Excel & Google Docs successfully, but it's returning "Err:508" in Calc 4.14

Code: Select all

=TEXT(LEFT(B2,8)-LEFT(A2,8)-(RIGHT(A2,2)>RIGHT(B2,2))/86400,"m:ss")&TEXT(MOD(RIGHT(B2,2)-RIGHT(A2,2),24),"\:00")
The idea is I enter something like this:

A2: 01:22:32:14
B2: 01:22:35:10

and the formula returns: 0:02:20 as the duration, this is for timecode calculated at 24 frames per second.

Unfortunately I'm nearly illiterate with formulas like this, and I can't figure out how to make it work in Calc.


Thanks in advance!
OpenOffice 4.1.4 Windows 10 64
User avatar
robleyd
Moderator
Posts: 5055
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Timecode calculator formula not working

Post by robleyd »

G'day, and welcome to the community forum.

AOO uses a semicolon (;) rather than a comma (,) to separate arguments in a formula. So for example where you have

Code: Select all

LEFT(B2,8)
you need

Code: Select all

LEFT(B2;8)
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
Post Reply