#1
|
|||
|
|||
Creating Shifts/Weekends 24/7 Employees
Hello,
I am using Excel 2013's Employee Attendance Tracker template, however we are a 24/7 business and not everyone's days off are the same. I want to be able to select an employee and have the calendar change to their exact days off. Right now there is a drop down menu to the right that says "Select an Employee" which changes the calendar to that persons attendance history. Also, it says my calendar is an Array and will not let me alter it. How do I change that? I would like to be able to mark S (sick) or T (tardy) on the dates, and have it calculate at the bottom. I attached the file that I am working with. I am not good with formula's, I would really appreciate the assistance! |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
reoccurring appointment that skips weekends | dovaka | Outlook | 1 | 04-10-2015 01:58 AM |
set daily goal for actual workdays, excluding weekends holidays and days off | Brian Reilly | Excel | 1 | 01-24-2014 11:56 PM |
Resources, subcontractors not employees | Gene2720 | Project | 3 | 06-11-2013 04:48 AM |
Recurring tasks falling on weekends - programme for working day prior | guyc | Project | 3 | 09-26-2010 03:32 PM |
IF statements that shifts to right. | kent | Excel | 0 | 01-19-2006 02:23 PM |