Converting Cell Data (QuiOui)
Posted by DSM on January 30, 2002 8:37 AM
Ok, again... thanks for the help on my previous issue. I have another questions! In this instance, I have dates that are in the form of yyyymmdd. I used the previous tip to convert my hhmmss to hh:mm:ss and placed that data in a seperate column. First, how can I convert the yyyymmdd into an easily recognized form (maybe mm/dd/yy or something) and then calculate working days from the date and time. Do I, and how would I, figure that from the two seperate columns (date col. and time col.)?