Hi
I am currently in the process of bringing our company data into Dataverse across from SharePoint. One of the things we want to capture is our unit's days and hours of operation.
For example, for one unit (the row) we would want to say:
Monday 08:00 - 16:00
Tuesday 08:00 - 16:00
Wednesday 08:00 - 16:00
Thursday 08:00 - 16:00
Friday 08:00 - 13:00
Saturday 08:00 - 12:00
Sunday Closed
What would be the best way to capture this in tables? For days of the week I was thinking we could do a multi choice column with the days of the week but how would we capture the time to correspond to the days as each day may have a different operating hour?
The only think I can think of is to have 14 columns, an open and close time column for each day, but that seems quite a long way around it?
Can anyone help me with a better solution?
Many thanks
Tom