I am working on an "availability" table for my solution. The idea is that a contractor will tell us what time they are available to work on a given day (e.g. 4PM - 11PM). I would like to take the result of those two dates (which would be created in Available::TimeStart and Available::TimeEnd fields).
I would like to create a list of hours that they are available (in this case, 4,5,6,7,8,9,10) that could then be used to create individual records in a related table (HoursAvailable) allowing that person to be scheduled based on the main calendar.
Does the community have any thoughts on ways to approach this?