Sharepoint List - Add an Hours of Operations field

[RSeepersad]

Hi,

I have a list that I am using as a form for an activity. I want to add a column for the hours of operation of a place. Does anyone know how add a new column that will allow users to add date and hours in the format of Monday 9:00 AM - 5:00 PM, maybe in the form of checkboxes or something dynamic other than manual text?

Thank you!

[#2 · Accepted solution]

Hi @RSeepersad,

To add a column for the hours of operation in SharePoint list, you can follow these steps:

1. Go to your SharePoint site and navigate to the list where you want to add the column.
2. Click on the "Settings" (gear) icon and select "List settings" from the dropdown menu.
3. Under the "Columns" section, click on "Create column."
4. Choose a column type that suits your requirements. In this case, you can use the "Choice" column type.
5. Provide a name for the column, such as "Hours of Operation."
6. In the "Type each choice on a separate line" section, enter the available hours of operation options. For example:
- Monday 9:00 AM - 5:00 PM
- Tuesday 9:00 AM - 5:00 PM
- Wednesday 9:00 AM - 5:00 PM
- ...
7. Select the appropriate display format for the column. You can choose either "Dropdown" or "Radio buttons" based on your preference.
8. Specify any other settings for the column, such as whether multiple selections are allowed or if it's a required field.
9. Click on "OK" to save the column.

Now, when users add or edit an item in the list, they will be able to select the hours of operation from the choices you provided in the column. The selected value will be stored for each item.

Note that this approach provides a predefined set of options for the hours of operation, and users can select one of them. If you need a more dynamic solution where users can enter custom hours, you might need to consider using other column types or customizations using SharePoint Framework (SPFx) or Power Apps.

Kindest regards

Leon Pavesic