24 7 shift schedule template excel

14View large imageTemplate 15: 24-hour schedule,landscape, 1 page,2 columns of 12 hours eachTemplate 15:24-hour schedulelandscape1 page, landscape orientation (horizontal)midnight to midnightfree to download, editable, customizable, easily printablefor Microsoft Excel (.xlsx file)Download template 15View large imageTemplate 16: Weekly hourly scheduling sheet,landscape, 1 page, 13 hours from7am to 8pm in 15-minute intervals,for one week or for up to 5 peopleTemplate 16:Weekly hourly scheduling sheetlandscape, 15-minute intervals1 page, landscape orientation (horizontal)covers the 13 hour period from 7am to 8pm, accommodating the majority of business hours15-minute intervals between 9am and 6pm (30-minute intervals before 9am and from 6pm)headers left empty for flexibility - use it as working week/5 day schedule or for up to 5 people, categories or other classification of your choiceno superfluous design elements - designed to maximize the available space on the sheetfree to download, editable, customizable, easily printablefor Microsoft Excel (.xlsx file)Download template 16View large imageTemplate 17: Weekly hourly schedule,landscape, time planning layout(6am to 12 midnight in 1 hour intervals)Template 17:Weekly hourly schedulelandscape, 1 hour intervals1 page, landscape orientation (horizontal)hourly schedule maker for Sunday through Saturday, covering 18 hours from 6 a.m. to 12 a.m. (midnight) in one-hour intervalsblank weekly schedule by the hour, covering 18 hours from 6 a.m. to 12 a.m. (midnight) in one-hour intervalshandy for planning all kinds of weekly activitiesfree to download, editable, customizable, easily printablefor Microsoft Excel (.xlsx file)Download template 17View large imageTemplate 18: Weekly half-hourly schedule,landscape, time planning layout(6am to 12am in half-hour intervals)Template 18:Weekly half-hourly schedulelandscape, 30-minute intervals1 page, landscape orientation (horizontal)blank weekly schedule (Sunday through Saturday) covering 18 hours from 6 a.m. to 12 a.m. (midnight) in 30-minute intervalsdays lined for easy use as hourly, daily or schedule maker (for shifts, work, learning and many other applications)free to download, editable, customizable, easily printablefor Microsoft Excel (.xlsx file)Download template 18See also:Other schedules: daily · weekly · monthly · quarterly · yearlyCalendars for 2025: weekly · monthly · quarterly · yearlyMulti-year calendars: split year · school year · academic year · fiscal year · two years · three yearsHourly schedule templates in other file formats: Word · Excel · PDFFlexible hourly schedules / shift

Categories or other classification of your choicefree to download, editable, customizable, easily printablefor Microsoft Excel (.xlsx file)Download template 5View large imageTemplate 6: Simple hourly schedule,portrait, 1 page, 18 hours from6am to 12am in 30-minute intervalsTemplate 6:Simple hourly scheduleportrait, 30-minute intervals1 page, portrait orientation (vertical)covers the 18 hour period from 6am to 12am (midnight) in 30-minute intervalsfree to download, editable, customizable, easily printablefor Microsoft Excel (.xlsx file)Download template 6View large imageTemplate 7: Weekly hourly scheduling sheet,portrait, 1 page, 17 hours from7am to 12am in 15-minute intervals,for one week or for up to 5 peopleTemplate 7:Weekly hourly scheduling sheetportrait, 15-minute intervals1 page, portrait orientation (vertical)covers the 17 hour period from 7am to 12am (midnight)15-minute intervals between 9am and 9pm (30-minute intervals before 9am and from 9pm)headers left empty for flexibility - use it for as 5-day/one-week schedule or for up to 5 people, categories or other classification of your choiceno superfluous design elements - designed to maximize the available space on the sheetfree to download, editable, customizable, easily printablefor Microsoft Excel (.xlsx file)Download template 7View large imageTemplate 8: 24-hour schedule,portrait, 1 page,24 hours in 2 columns, linedTemplate 8:24-hour scheduleportrait, graded red/blue1 page, portrait orientation (vertical)covers 24 hours (midnight to midnight) for around-the-clock planningdivided into two columns of 12 hours eachleft column (in graded red): 12am (midnight) to 12pm (noon)right column (in graded blue): 12pm (noon) to 12am (midnight)linedfree to download, editable, customizable, easily printablefor Microsoft Excel (.xlsx file)Download template 8View large imageTemplate 9: Hourly schedule,portrait, 1 page, 24 hours in 2 columnsTemplate 9:24-hour scheduleportrait1 page, portrait orientation (vertical)covers 24 hours in 2 columns of 12 hours (midnight to midnight)1-hour intervalsleft column: 12am (midnight) to 12pm (noon)right column: 12pm (noon) to 12am (midnight)free to download, editable, customizable, easily printablefor Microsoft Excel (.xlsx file)Download template 9View large imageTemplate 10: 48-hour schedule,portrait, 1 page,24 hours in 1-hour intervalsTemplate 10:48-hour scheduleportrait1 page, portrait orientation (vertical)48 hours on one page (48H1P)covers 24 hours in 1-hour intervalspm hours marked in bold to distinguish them from the am hoursfree to download, editable, customizable, easily printablefor Microsoft Excel (.xlsx file)Download template 10See also:Other schedules: daily · weekly · monthly ·

I was recently asked if it would be possible to convert my annual calendar template into an automated work rotation schedule, for an employee who is working a rota consisting of a number of days on followed by a number of days off. The result was the new template listed below.For other related scheduling templates, see the work schedule and shift schedule.Advertisement for Excel and Google SheetsAbout this Rotation Schedule SpreadsheetThis template provides a convenient way to display your work rotation schedule, using the annual calendar template as a basis. Just enter the year and start month, then use the other inputs to define your shift schedule pattern. The workbook contains 3 separate worksheets, each providing a slightly different set of features.In the first two worksheets (Rotation and Rotation_Advanced), the rota schedule is defined by entering the numbers of days on Shift 1, followed by the number of days on Shift 2, followed by the number of days off. For a simpler "days on/off" pattern, just leave the "Shift 2" field blank.In the Rotation_String worksheet, you can define a rotation as a repeating string such as "11xxx22xx333xx" which would mean that you work Shift 1 for 2 days, followed by 3 days off, followed by working Shift 2 for 2 days, followed by 2 days off, followed by working Shift 3 for 3 days, followed by 2 days off.Both the Rotation_Advanced and Rotation_String worksheets use the new built-in function NETWORKDAYS.INTL(), available as of Excel 2010, to let you choose which days make up the "weekend" (Sat/Sun, Mon/Tue, Sunday only, etc.) and to also account for holidays. In these worksheets, the rotation excludes both weekend days and holidays, all of which we call "non-working days." This means that if the rotation calls for you to work 2 days starting on Friday, then you would work Friday and then Monday (skipping the non-working weekend days).The workbook contains a "Holidays" worksheet where you can list days that should be considered non-working days. Rotation Schedule for Multiple EmployeesDownload ⤓ Excel (.xlsx)For: Excel 2010 or later & Excel for iPad License: Private Use (not for