Mastering Development

VBA – sort list with start and end times that crosses the date border

I have a Excel list job batches, where each batch consists of multiple scheduled jobs. For each batch and each job a start and end time is specified. The list is sorted by start time of batches and then by start time of jobs within each batch. However, this sorting creates issues if batches and […]