Closed

Excel Timecode to Text Automation Script

This project was awarded to ZeusMan for £30 GBP.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
£20 - £250 GBP
Total Bids
19
Project Description

Hello,

I would like a script or some sort of an automation that converts an Excel spreadsheet like this:


Sequence0001 00:00:00:00
Sequence0001 00:00:03:02
Sequence0001 00:02:05:13
Sequence0001 00:04:01:20
Sequence0001 00:04:58:01
Sequence0001 00:05:14:24
Sequence0001 00:06:28:01
Sequence0001 00:06:42:16
Sequence0001 00:07:46:09
Sequence0001 00:09:41:20

to an html (or text) document like this:

<chart>
<!-- 1 -->
<timecode>00:00:00</timecode>
</chart>

<chart>
<!-- 2 -->
<timecode>00:00:03</timecode>
</chart>

<chart>
<!-- 3 -->
<timecode>00:02:05</timecode>
</chart>

<chart>
<!-- 4 -->
<timecode>00:04:01</timecode>
</chart>

<chart>
<!-- 5 -->
<timecode>00:04:58</timecode>
</chart>

<chart>
<!-- 6 -->
<timecode>00:05:14</timecode>
</chart>

<chart>
<!-- 7 -->
<timecode>00:06:28</timecode>
</chart>

<chart>
<!-- 8 -->
<timecode>00:06:42</timecode>
</chart>

<chart>
<!-- 9 -->
<timecode>00:07:46</timecode>
</chart>

<chart>
<!-- 10 -->
<timecode>00:09:41</timecode>
</chart>

I look forward to hearing from you.

Thanks,

Arran

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online