Can this be done? Timeline Slicer by hour not day

Hello,

I need some help with an excel project.

I have many companies and their hours of operations and would like to input the current time and find out which companies are currently open and will be open for the next "x" number of hours.

Example:

Company A is Open from 8:00 - midnight
Company B is Open from 10:00 - 21:00
Company C is Closed on Mondays

Now = Monday 18:05
Company A is open now and will be open 2 hours from now
Company B is open now but will be closed 2 hours from now
Company C is closed now
etc...


How do I build out a table listing open and closed hours for each day of the week (and holidays)?
How can I know whether they are open and how much longer are the opened for the day?

In the end, I would like to use Power BI to show locations that are currently open and will still be open x hours from now.

Thanks in advance!!!