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):

| 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 |

=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:

Get instant access to
our educational content

Start practising and learning.

Your name

No Error

Phone number

No Error

*By submitting your phone number, we have
your permission to contact you regarding
Geniebook. See our Privacy Policy.

Let’s get learning!

Download our educational
resources now.

Error

Oops! Something went wrong.
Let’s refresh the page!

Claim your free demo today!

*By submitting your phone number, we have your permission to contact you regarding Geniebook. See our Privacy Policy.

Turn your child's weaknesses into strengths

Get a free diagnostic report of your child’s strengths & weaknesses!

Your Name

Phone Number

Error

Oops! Something went wrong.
Let’s refresh the page!

Error

Oops! Something went wrong.
Let’s refresh the page!

We got your request!

A consultant will be contacting you in the next few days to schedule a demo!

Return to Homepage

Reload Page

*By submitting your phone number, we have your permission to contact you regarding Geniebook. See our Privacy Policy.

Excel - To Srt

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):

=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: