Hello everyone!
I have an excel file has attached. The data has time stamps arranged from 6am to 6pm everyday for a whole year. But we decide to make it 12 am to 12pm everyday. Since the data is in 10 minutes time stamps, this means I need to add rows for 12am to 5:50am and 6:10 pm to 11:50pm everyday for a whole year. Does anyone know a faster method to do this without having to create this rows for each day?
PS: The attached data is a sample. For every day, I have additional set of data. This means for the new rows created everyday i.e., 12am to 5:50am and 6:10 pm to 11:50pm, I need to copy and paste these additional data as well.
Thanks alot for the help.
Bookmarks