Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting a string date into a Excel Date
I have a website I need to import data from.
It has the date listed like "Tuesday November 25th" and then below it, the time, class and then the instructor I would like to have it import the data and then have it like Date Time (or date and time as one field) Class Instructor. How can I do this? There might be different classes per day, and some days, no classes. Here is a sample of this weeks schedule. Thanks Phil Monday November 24th 1:30 PM CST - Training Call First_Name lastName 8:30 PM CST - New Rep Training First_Name lastName Tuesday November 25th 1:30 PM CST - New Rep Training First_Name lastName 2:30 PM CST - Team Calls First_Name lastName 8:30 PM CST - Training Call First_Name lastName Wednesday November 26th 1:30 PM CST - Training Call First_Name lastName 8:30 PM CST - New Rep Training First_Name lastName Thursday November 27th No New Rep Training - Thanksgiving Day No Team Calls - Thanksgiving Day No Training Call - Thanksgiving Day Friday November 28th No New Rep Training - Thanksgiving Holiday Saturday November 29th No New Rep Training - Thanksgiving Holiday |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting hijri date to gregorian date | Excel Discussion (Misc queries) | |||
Convert Date string to date format | Excel Discussion (Misc queries) | |||
Converting text format of time/date into Excel time/date for subtr | Excel Worksheet Functions | |||
Converting a date to a text field w/o converting it to a julian da | Excel Worksheet Functions | |||
Converting a year date into a specific day date | Charts and Charting in Excel |