CustNo t1 t2 t3 t4 t_date t_time 35995 0 0 0 300 2008152 4159 35995 0 0 0 303 2008152 4159 35995 20 0 120 226 2008152 8849 35995 0 0 0 0 2008152 9080 35995 1 0 2 5 2008152 9075 35995 0 0 0 0 2008152 9081 35995 0 0 0 232 2008152 8849
These are transactions from transaction log generated by the application. The t_date is in "julian date" format and i would like to convert into "MM/DD/YY format" and combine t_date & t_time into one col. Also, t1,t2,t3,t4 col are filled in a 24 hr frame so would like these to be sum per date. How do I do all these in one macro. --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
