Looking for assistance creating a batch file or script to run against an excel document to particularly convert a field of raw data as such:
"Sat Aug 03 08:54:48 SGT 2019"
Into 2 separate fields resulting in
HH:MM (24 HR FORMAT)
Excel file dump has hundreds and thousands of records, almost impossible to do this manually on a frequent basis.
20 freelancere byder i gennemsnit $109 på dette job
I can provide you a simple VB function that will convert your raw data into two separate fields as you want. You'll get a working script in 2-3 hours for just 140 SGD.
$ 30 SGD Only ------ In just 2 Hours ------- Excel Data Management, VBA Macro Coding, Automation and Formula Generation Expert ---- I can create your VBA Macro script with a dedicated button.
Hi there, There's no need for a separate script. Just a couple of excel functions will do the trick. Trust me. It is a small task and I can do it in 5 mins.