create automated time and replace few keywords excel formulae

geetethan

New Member
Joined
May 19, 2016
Messages
8
i want to get automated add time for every 00:01:05, example 00:00:00,00:01:05,00:02:10,00:03:15. like this i want upto 5 hours.... example :

A(original)B (time changed)C
ffmpeg -i zxcv.mp4 -ss 00:00:05 -t 00:00:7 -codec copy output.mp4ffmpeg -i zxcv.mp4 -ss 00:01:10 -t 00:00:7 -codec copy output.mp4
ffmpeg -i zxcv.mp4 -ss 00:02:15 -t 00:00:7 -codec copy output.mp4

<tbody>
</tbody>

see in column B the time has to get updated for every 1 minute 5 seconds.00:01:05,

A ( time was done )B (keywords for replacing)C (change output keyword to B column keywordsD
ffmpeg -i zxcv.mp4 -ss 00:01:10 -t 00:00:7 -codec copy output.mp4affmpeg -i zxcv.mp4 -ss 00:01:10 -t 00:00:7 -codec copy a.mp4
ffmpeg -i zxcv.mp4 -ss 00:02:15 -t 00:00:7 -codec copy output.mp4bffmpeg -i zxcv.mp4 -ss 00:02:15 -t 00:00:7 -codec copy b.mp4
ffmpeg -i zxcv.mp4 -ss 00:03:20 -t 00:00:7 -codec copy output.mp4cffmpeg -i zxcv.mp4 -ss 00:03:20 -t 00:00:7 -codec copy c.mp4

<tbody>
</tbody>

I need formula very badly thanks for the help..))))))
 

mrCostas

New Member
Joined
Jul 27, 2016
Messages
18
You can write 00:00:00,00:01:05 one below the other and select the two cells and drag from the bottom right corner up to the 5 hour mark.
 

Forum statistics

Threads
1,085,335
Messages
5,383,032
Members
401,812
Latest member
topherj09

Some videos you may like

This Week's Hot Topics

Top