How do I subtract time where hh:mm:ss:ff (frames = 30 frames/s
hi! please convert this to 25 frames per second (pal video) ty
"Gary''s Student" wrote:
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
--
Gary''s Student - gsnu200734
|