Adjusting the time across midnight for holidays
The implementation of business time calculations requires that Start Time be earlier than End Time. However, when a holiday schedule crosses midnight, such as when Start Time is 10:00:00 P.M. and End Time is 6:00:00 A.M., you must adjust the holiday schedule:
- To adjust using Holidays time, enter the start time as one day and enter the end time on the next day. It would look like:
12/25/04,10:00:00 P.M.,11:59:59 P.M.; 12/26/04,12:00:00 A.M.,6:00:00 A.M.
- To adjust using Offset Hours, take your original Start/End time minus the value from Offset Hours in the Business Time Workdays form to get the adjusted time. You can use either a positive offset (which moves the times earlier) or a negative offset (which moves the times later). The offset does not have to be unique. You can choose any value as long as the adjusted times fall into the 0- to 24-hour range. For example, if a holiday starts at 10:00:00 P.M. on 12/25/04 and ends at 6:00:00 A.M. on 12/26/04, you can supply an offset of three hours to adjust the holiday time to start on 12/26/04 at 1:00:00 A.M. and end at 9:00:00 A.M. This adjusted time is entered into the Holidays field following the format:
12/26/04,1:00:00 A.M.,9:00:00 A.M.
The offset hours is specified in Business Time Workdays as part of a workday schedule.