Hello,
I am running a query on multiple spreadsheets within a folder to display a consolidated set of data.
The problem I have run into and unable to get through completely revolves around column labeled "Insp View" in image below.
Values in this column from spreadsheets match format of top 5 rows, HH:MM.
However, I need to leave the cells with value of 00:00 alone and do not want them adjusted to 12:00.
Example: 12/31/1899 6:00:00 AM = 06:00 BUT also want 00:00 = 00:00
Any help would be greatly appreciated! I have spent a lot of time trying to muddle through this. Haha.
I would also like to add, I am planning on new spreadsheets being added to folder and thus to query from time-to-time which is why I have gone this direction. The format of new spreadsheets added will match the current spreadsheets exactly.
Thank You!
I am running a query on multiple spreadsheets within a folder to display a consolidated set of data.
The problem I have run into and unable to get through completely revolves around column labeled "Insp View" in image below.
Values in this column from spreadsheets match format of top 5 rows, HH:MM.
However, I need to leave the cells with value of 00:00 alone and do not want them adjusted to 12:00.
Example: 12/31/1899 6:00:00 AM = 06:00 BUT also want 00:00 = 00:00
Any help would be greatly appreciated! I have spent a lot of time trying to muddle through this. Haha.
I would also like to add, I am planning on new spreadsheets being added to folder and thus to query from time-to-time which is why I have gone this direction. The format of new spreadsheets added will match the current spreadsheets exactly.
Thank You!
