the company posts all employee info as one GIGANTIC spreadsheet. it takes a long time to load, and is very unorganized.
I'm trying to import events from IXE Toal view
which looks like this before posting
http://www.qpc.com/Eu/Images/IEXTota...eduler-lge.gif
into a
Google Calendar readable format
which would look like this
https://docs.google.com/spreadsheet/...UE&usp=sharing
following this guide
http://n8henrie.com/2013/05/spreadsheet-to-calendar/
right now i have copied all info from {nonadmn} as a txt file. here it is times.txt
also the ''Open Time TIME PM TIME PM'' serves no purpose to me
I'm trying to
export to a readable format for Google Calender and have had no luck for two weeks. so finally, I'm turning to people who understand macros, spreadsheets, and data editing.
Any ideas guys?
How to read it.
Agent name Agent id
Date Start End Scheduled Activity Start End <-- this line shows as headers in the spreadsheet.
11/16/14 Off Off means do not work on that day.
11/18/14 1:00 PM 9:30 PM Open Time 1:00 PM 2:45 PM
Date- Time start, time stop, open time1:00 PM 2:45 PM is again, pointless.
Break Time start time end
and so on.
I'm trying to get each item to show as a Google Calender event.
Bookmarks