Answer

In Excel, set opening hours for each weekday. For hours that cross midnight, use an "end-time" of 00:00 on the first day and a "start-time" of 00:00 on the next day to create a continuous interval.