Will Musescore provide the functionality to output as subtitle files, like ".srt"?
I made a sheet, to be a semi-automatic subtitle converter:
https://docs.google.com/spreadsheets/d/1ZLyCYlOCoUpwiWaNG7glP0vV3AnC25E…
All I need to do is fill in the relevant information in the "yellow area", then copy the corresponding "Result" cell in the "blue area" next to the last sentence of the lyrics.
For example, see diagram below:
1.Choose like the 2nd section, then the "Time is 0:00:02:7"
2.Fill "0 0 2 7" to each "yellow area(in row, even, you can ignore the Zero).
3.In the last, copy the "blue area" next to the last sentence of the lyrics.
4.Copy to somewhere, like a ".txt" file.
5.Delete the " mark, in the first line and the last line.
6.Change the file extension to ".srt"
7.Done, import it to where you need it~
(I think, it is stupid...but, it work~)
btw, the formula for each cell, is:
G3=IF(SUM($B4:$E4),B4,B3)
H3=IF(SUM($B4:$E4),C4,C3)
I3=IF(SUM($B4:$E4),D4,D3+5)
J3=IF(SUM($B4:$E4),E4,E3)
M3=TEXT(TIME(B3,C3,D3),"hh:mm:ss")&","&INT(E31000/10)&" --> "&TEXT(TIME(G3,H3,I3),"hh:mm:ss")&","&INT(J31000/10)
N3=N2&A3&CHAR(10)&M3&CHAR(10)&K3&CHAR(10)&CHAR(10)
Attachment | Size |
---|---|
toSRT_musescore.png | 25.65 KB |
toSRT_converter.png | 23.56 KB |