Adjusting the time across midnight for holidays

The implementation of business time calculations requires that Start Time be earlier than the 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 as follows:

Related topics

Scheduling-workdays

Scheduling-holidays

  • To adjust using Holidays time, enter the Start Time on one day and enter the End Time on the next day in the following format:

    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, subtract the original Start/End time with 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 time falls 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 in the following 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.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*