Format and Filter Data
$10-30 AUD
Оплачується при отриманні
I have an excel workbook comprised of raw data for the last 10 years split into 5 minute time periods.
The time and date is in Chicago time with the date written as a number with no seperators. For example the 17th July 2011 will be written as 110717. And the 18th July 2005 would be written as 50718
I firstly need the date formatted to dd/mm/yyyy and the time converted to sydney time. To do this you will need to take into account the daylight savings periods for both Sydney and Chicago.
Once this is done I need to isolate the data from the following two time periods each day.
- 9:50am - 10:20am (Sydney time)
- 4:00pm - 5:40pm (Sydney time)
The file is 23MB so I cant attach it here but will send it to you once the job has been accepted.
ID Проекту: #7990260
Про проект
28 фрілансерів(-и) готові виконати цю роботу у середньому за $40
Hello, I am good at excel and able to complete this job quickly. Would you share the source file, please? I am ready to start immediately. Best regards, Hoang
Expert in excel, excel functions , macros, pivot tables and charts can format the date and time as per the required format. The bit amount is quoted as 88 as the file is 23 MB . the processing time will be very slow to Більше
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro conta Більше
Hello, I've expertise in excel . I've read the details about the project. I assure you that the project will be completed with best quality. So waiting to hear positive response from your side. Thanks
i am ready to do the job. it will take time. just a little clearance needed. i am from pakistan. we dont have daylight saving time. so i want to know which period you are using daylight saving time so that i can put so Більше
Hi, Your project sounds very interesting and simple enough and I believe that I'll be able to perform the task perfectly. As for my experience, you can see for yourself that I've worked here mainly as a content a Більше
Excel Expert. Job is complex. Can do. Best regards, AccuPro......................................................................
Hi, I am used to handling large excel files and process them using formulas and VBA. If you want, I can do this for you. Thanks.
this sounds like a real easy Excel solution, I can do this for the minimum rate. Practically free. please award this to me and it should only be a few minutes work.
Hello, I can get the thing done for you. If you would like to try it on your own, you can try "RIGHT" function to fetch year and month. You can use "SUBSTITUTE" function to get the date (by substituting month and y Більше
Hi I am from Malaysia,I am a dedicated worker. I can works for long hours on computer and have a good skill in Words and Excel also in English language
Hello, Being an annalist, part of my job is working with Excel and databases so I can guarantee quality work. I and am almost fluid in English and have 10 mb/s internet connection. Hope to discuss details of the proj Більше
Can negotiate and complete the work according to your timeline as well if the project is awarded to me.
Hi, We have coded several crawlers and data processing tools using excel and custom codes. Your task is very easy and I would like to help you with this task. Have a nice day, Radu