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.
29 freelancers estão ofertando em média $40 para esse trabalho
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
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
The project no doubt is simple. However, the size of the file appears to be [login to view URL] provide a sample portion of the file, so that I can get a better idea. Please message for discussion
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.