So the team is looking for a simple way to view and report on Office hours for Accounts that the field reps are visiting. 

I have exprimented with multiple methods such as creating custom Objects or custom fields but niether were easy to read/ report on/ add to a list view.

I have a method that would be the simplest to view and for the reps to see on their list views and reports.

I will have picklist items for each day of the week for a start time and end time for their office hour (I will give an example for three days to make the formula simple):
Monday From: 1:00pm 
Monday to: 8:00pm
Tueday From: CLOSED
Tuesday To: CLOSED
Wednesday: 8:00am
Wednesday: 3:00pm

The issue with this is that it's four fields, so reporitng and simply vewing is still not ideal.

So what I want to do is to create a formula field that will display the text items just for the open hours.

So the formula field will show this:

"Monday from: 1:00 pm to 8:00 pm
Wednesday from 8:00 am to 3:00 pm"

You see how every day is a separate line and how Tuesday is not included because it's CLOSED? 

One more addition is that I want to add a special note field which is a text field - Here's an example
Special Note: "Open on xmas and new years eve"

So it will be:

"Monday from: 1:00 pm to 8:00 pm
Wednesday from 8:00 am to 3:00 pm

Open on xmas and new years eve"

Is this possible to do?

Thank you.