346671 Excel Macro Unix Date Conv

Need an Excel Macro(s) written that will:

First, when Excel is opened will let us load a CSV file that allows the simple running of the needed macros.

1. Take the existing UNIX Date/Time Field: 2009-08-03 15:40:42 and split it into two different fields (Start Date and Start Time)and applies that change to all data in that column. Eastern Standard time if possible.

2. A macro that will ask the start time (this is for the listing time of an auction in the future) and the number of minutes auctions should be spaced apart and the row numbers affected. Once answered, the macro will make the first auction "Start Time" for the rows selected the time identified and will then make the next "Start Time" x min after the first. Objective is that if there are 5 or 500 items to list for auction that we have control on time spacing them apart. We need control over affected rows as we may wish to make the first 20 auctions 5 min apart and the second 20 10 min apart.

3. Final Macro will re-create the Unix Time Date Field but containing the new "Start Date and Start Time", in the same location as the original field and delete the individual fields (Start Date and Start Time)as no longer needed. At the same time it will modify another UNIX field (also containing the same formatted data but will be set to 48 hours after the data in the "start date" and "start time". No need to convert this data out of UNIX unless necessary.

4. A simple macro to create a CSV file

Happy to clarify any questions.

David

PS.

Odd Jobs PHP

ID dự án: #2092494

Về dự án