frames to seconds conversion formula not returning the same results

[melaniez]

Hello,

I've built a table to track video footage on a film production, using the INT formula.
My initial data is in frame, and I have put together a formula where when I replace "1" by my frame count (ex:107), the formula turns the frame number into seconds + frames (4:11). Note I'm converting at 24frame/seconds. (you can see the initial formula in column E, I've also included an extra "if" to keep the cell blank when i haven't yet added my data)

At the bottom I'm adding the total seconds per column and on the left I'm adding the total seconds per row, using again a combination of INT formulas to keep the totals in frames and not decimal. Both ways are correct. However the total for all rows and total for all columns turn out different results, as shown in the two bottom right cells (see attached spreadsheet).
I can't make sense of why those results would be different when they should be the same! if anyone has any idea about this, let me know!

 

[vletm]

Try to check this ..

 

[melaniez]

Thanks for looking into this vletm. Could you clarify which format you're using in your table? everything is coming up for me in a 12:00:00 AM format...
Also I have a feeling the formula you're using is still going to return a number where everything to the right of the . is going to be decimal and not frames...

 

[NARAYANK991]

Hi ,

All your totals are off by a slight amount.

Can you check the calculations in the uploaded file ?

Narayan

 

[vletm]

melaniez
I add few comments and results with seconds.
There is one 'yellow' sample: 24frames = 0:00:01 = 1sec

 

[NARAYANK991]

melaniez
I add few comments and results with seconds.
There is one 'yellow' sample: 24frames = 0:00:01 = 1sec

Hi ,

I think you should take a second look at what the OP wants.

In a value such as 17.15 , which is the result of a frames value of 423 , the integer portion of 17 is clearly the quotient when 423 is divided by the fps of 24.

The decimal portion is not an actual decimal value ; it is the remainder when 423 is divided by 24.

Thus 17 * 24 = 408 ; 423 - 408 = 15.

Narayan

 

[vletm]

NARAYANK991
You wrote 'I think you should take a second look at what the OP wants.'
I looked and find this: 'I can't make sense of why those results would be different when they should be the same! if anyone has any idea about this, let me know!'
... I tried to give some ideas. / VLE™

 

[NARAYANK991]

NARAYANK991
You wrote 'I think you should take a second look at what the OP wants.'
I looked and find this: 'I can't make sense of why those results would be different when they should be the same! if anyone has any idea about this, let me know!'
... I tried to give some ideas. / VLE™

Hi ,

That is because in the file which she has uploaded , there are two totals , one a row total in cell G26 , which displays the value 142.03 , and the other a column total in cell G25 , which displays the value 145.07

She wanted to know the reason for this difference.

That apart , the point I made is different ; your file makes the total of 159 and 247 frames ( 406 frames ) result in a displayed value of 16.92 ; I wanted to tell you that OP wants this displayed as 16.22 , since the 22 in the decimal portion is the number of seconds ( 22 ) which remain when 406 is divided by 24.

Narayan