Forum Discussion
Film Frame Calculations
I am trying to work out how to sum a film frame calculation. For example: 17:40:45:07 12:02:34:17 05:54:28:19 these are hours:minutes:seconds:frames 24 frames makes a second in this scenario (a...
Tess33 I'm glad the formula was useful! The formula would be applied in a separate column or you'd need it nested in the same formula which I shared calculating the duration?
- You'd need to put this formula in D2 for the rounded duration: =IF(NUMBERVALUE(RIGHT(C2,2))<12,LEFT(C2,8),LEFT(C2,8)+1/86400)
11 frames or less will round downwards and 12 frames or more will round upwards.- Thanks facruz. It works well for rounding up the duration. However I was looking for the formula which can find clips with the same name, count durations of these clips and then round the total duration up to seconds.
For example:
EDIT_Clip_01 (row 2 and 😎
00:00:03:00 + 00:00:02:19 = 00:00:05:19 ≐ 00:00:06:00
Is it possible or is that something that excel can't do at all?
Thank you
Tess