Employee Shift Schedule Excel template
 

How do I change the full hour columns to 1/2 hour columns in the Employee
Shift Scheudle Template for Excel?

You could insert additional columns, and change the headings for each day --

To insert columns:
Point to the button at the top of column E
Hold the mouse button, and drag across to column L
Choose InsertColumns
In cell E8, type: 7:30 AM
Select cells D8 and E8
Point to the fill handle (the small black square at the lower right of
the selection)
When the pointer changes to a black plus sign, drag across to column T
Then, select cells, D8:T8, and click the Copy button on the toolbar
Select cell D20, and click the Paste button on the toolbar

Paste the times into the remaining days.

drhenrie wrote:
How do I change the full hour columns to 1/2 hour columns in the Employee
Shift Scheudle Template for Excel?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html