Converting a string date into a Excel Date

P

Phillips

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How would I convert the following into a excel sheet? 1
Need calendar form to display holidays 1
Working Days of Week and DUE DATE for PAYMENT 4
convert date stamp to previous date 9
Getting and error while calculate business hours between 2 dates with holidays. 4
Grouping/Deleting Dates/Times (HELP ANYONE!) 2
Excel Formula Help please 3
Rosh Hashanah and Yom Kippur Holiday Dates Revisited 1

Top