Use sp_add_time_range to:
Name the time range
Specify the days of the week to begin and end the time range
Specify the times of the day to begin and end the time range
See sp_add_time_range in the Reference Manual: Procedures.
