Hello,
I have to make a pivot table based on time in half hour intervals, but I'm having to manually enter in the time window, so I want to automate this process.
How do I get the "start time" section in column B put into 30 min time intervals like in column C?
I've tried doing it with VLOOKUP but I keep getting #N/A, unless copy and paste the the date from the "Test" tab as highlighted in red.
I attached the file I'm working on.
Dave
Bookmarks