Excel Schedule

Owned by Julie Leake (Unlicensed)
Last updated: Jul 05, 2019 by mhigginbotham (Unlicensed)

Report Options

OptionDescription
Filter

Mode—Choose to display the data by Schedule Group

Schedule Group—Select which Schedule Groups should be included in the report.

Display

Date Range—Determine the date the report begins and ends.

Employee Data—Denote that you want the employee's Name and/or Employee ID included in the report.

Scheduled Shifts—Choose to see the time the shifts starts and how long the shift lasts or the Start Time and End Time of the shift. You can also choose to have the time shown in 24-hour format.

Unscheduled (Show as)—Denote that Unscheduled employees will be shown as "Off."

Miscellaneous—Choose to see Employee Totals on the report.

Running the Report

To run the report:

  1. Choose Scheduling from the Reports menu.
  2. Click All Scheduling.
  3. Select Excel Schedule.
  4. Select the appropriate Schedule Group(s).
  5. Select Start Time / Shift Duration or Start Time / End Time from the drop-down menu.
  6. Select or de-select Show time in 24-hour format.
  7. Select or de-select Options.
  8. Click OK. The report is displayed.