Hi All,
I need help writing vba code that will do the following:
I have a report that shows time intervals in column A and number of calls in column B. I need the start time and end time of the ranges of time where the calls exceed 30. So for the spreadsheet that i attached i would need the the macro to return 8:30 AM-11:00 AM, 12:30 PM-2:30 PM, and 3:30 PM-5:00 PM in three different cells. Since there is more than one range i would need the macro to be able to find multiple ranges and return results to multiple cells.
Any help would be greatly appreciated.
MJW
Bookmarks