none
How to create a list with split opening hours

    Question

  • Hi,

    I need your assistance in figuring out how to build a list correctly.

    In my list I want to show names of public organizations and their hours of service.

    For example:

    Bank Hapoalim opening hours:

    Sun, Tue, Wed 08:30-13:15

    Mon, Thu 08:30-13:00 and 18:30-18:00

    Fri - Close

    I would like suggestions as to how to put it into a list that could be searched as follows:

    Bank opening hours 9:00AM ?

    I figure that putting it as a text column won't give me the option to search for when the organization is open (specific hour).

    I'll appreciate your suggestions,

    Thanks,

    Inbal

    Thursday, March 14, 2013 9:12 AM

Answers

  • You can go by following this:

    1. Create a site column called Start Time as either of type "Data and Time" or single line of text.

    2. Add the site column to your list.

    3. Add list items with entries to Start Time.

    4. Complete a crawl - we're doing this because you mentioned the values need to be searchable.

    5. Create a managed metadata column to map it with the site column.

    6. Complete a crawl.

    7. Repeat steps 1 to 6 for End Time.

    8. Search for results based on the keywords like starttime:9AM or similar.

    Wednesday, March 27, 2013 2:27 PM

All replies

  • Hi,

    Thank you for your question. I am trying to involve someone familiar with this topic to further look at this issue. There might be some time delay. Appreciate your patience. Thank you for your understanding and support.

    Thanks,

    Entan Ming

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contacttnmff@microsoft.com.


    Entan Ming
    TechNet Community Support

    Friday, March 15, 2013 6:06 AM
    Moderator
  • Looking forward to hear any solution to the problem.

    Thanks,

    Inbal

    Sunday, March 17, 2013 10:32 AM
  • You can go by following this:

    1. Create a site column called Start Time as either of type "Data and Time" or single line of text.

    2. Add the site column to your list.

    3. Add list items with entries to Start Time.

    4. Complete a crawl - we're doing this because you mentioned the values need to be searchable.

    5. Create a managed metadata column to map it with the site column.

    6. Complete a crawl.

    7. Repeat steps 1 to 6 for End Time.

    8. Search for results based on the keywords like starttime:9AM or similar.

    Wednesday, March 27, 2013 2:27 PM
  • Thank you, I'll try it.

    Tuesday, April 02, 2013 4:48 AM