I am looking for someone that can provide an excel formula and complete the following file. Column I and K titled ORIGDATE & ORIGTIME needs to be formatted with excel formula to reflect the directions below.
Please complete the examples and provide the formula.
Originating Date (ORIGDATE). The originating date of the call. The format is YYYYMMDD (20160101). This date may be representative of a conversion to local time.
Originating time of the call (ORIGTIME). The format is HHMMSSTTT (230915000), where HH is 00-23 hours, MM is 00-59 minutes, SS is 00-59 seconds, and TTT is 000-999 milliseconds. This time may be representative of a conversion to local time.
Please provide an example of the completed file so I can award the project as soon as possible.
38 freelancers are bidding on average $23 for this job
i try to do this project in my best. Relevant Skills and Experience i have more than 10 year experience with excel Proposed Milestones $22 USD - aaaa Additional Services Offered $1 USD - as you request wh