Write in excel



I have extracted a time period like 5PM-9PM format, but now i have to write the same in excel. How to do that if each header cell in excel represents an hour and you have to write it as 1 under each hour which has been extracted.


first you can build the data table with the column headers as the 5pm, 6pm and soo on whenever you extracted the data you can add that specific data to that col and write the complete table to excel at once