The timestamps on YouTube are often not in my preferred format (I copy and paste to Notepad) so I had to either change them all manually or let Excel do it for me.
The images below show how I accomplished this.
Image 1: My entire sheet with some of the data broken down into columns.
Image 2: The formulas I used in my sheet (I used the FormulaText function for this)
I hope this helps someone else accomplish a similar task.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
