=A2 & CHAR(10) & B2 & " --> " & C2 & CHAR(10) & D2 & CHAR(10) & CHAR(10) Drag down for all rows. In a new cell (e.g., F1), enter:
| A (Subtitle Index) | B (Start Time) | C (End Time) | D (Text) | |--------------------|----------------|--------------|-----------| | 1 | 00:00:01,000 | 00:00:03,500 | Hello world | | 2 | 00:00:03,600 | 00:00:06,000 | This is an example |
HH:MM:SS,milliseconds (comma before ms) ✅ Step 2: Build the SRT Block in a New Column In column E , enter this formula (for row 2, adjust as needed):
⚠️ 充值前請務必詳閱下列內容，並確認您已充分理解與同意，方可進行充值操作。若您不同意，請勿儲值：
自 2025 年 7 月 8 日 00:00:00 起，凡透過任一方式（包括儲值、稿費轉入等）新增取得之海棠幣，即視為您已同意下列規範： excel to srt
📌 如不希望原有海棠幣受半年效期限制，建議先行使用完既有餘額後再進行儲值。 =A2 & CHAR(10) & B2 & " -->
📌 若您對條款內容有疑問，請勿進行儲值，並可洽詢客服進一步說明。 000 | 00:00:03
=A2 & CHAR(10) & B2 & " --> " & C2 & CHAR(10) & D2 & CHAR(10) & CHAR(10) Drag down for all rows. In a new cell (e.g., F1), enter:
| A (Subtitle Index) | B (Start Time) | C (End Time) | D (Text) | |--------------------|----------------|--------------|-----------| | 1 | 00:00:01,000 | 00:00:03,500 | Hello world | | 2 | 00:00:03,600 | 00:00:06,000 | This is an example |
HH:MM:SS,milliseconds (comma before ms) ✅ Step 2: Build the SRT Block in a New Column In column E , enter this formula (for row 2, adjust as needed):
瀏覽啟示