#1
|
|||
|
|||
Using COUNTIF to give start and finish times on staff schedule.
Hi there,
I would like to create a sheet for a staff schedule. I have one sheet that uses COUNTIF to find out when a staff member is working. For every hour the staff member works (7am, 8am, 9am) a letter indicates where they work. COUNTIF tells me how many hours they work. 8am until 4pm. 8 hours. Is it possible to send some information from this sheet to another that basically says a start and finish time for a particular staff member? This sheet would be viewed by staff as their roster/ schedule. Thanks in advance |
#2
|
||||
|
||||
Can you attach a workbook with your plan?
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
COUNTIF [criteria] + give % | Tomas4 | Excel | 2 | 12-20-2016 10:28 AM |
what to put in to schedule for dealing with overall finish date | ketanco | Project | 7 | 10-30-2014 02:25 PM |
Milestones with different start and finish dates | ketanco | Project | 2 | 09-17-2014 05:21 PM |
Team Planner-maintaining accuracy in task start and finish times | david_23 | Project | 9 | 04-19-2012 08:33 AM |
displaying start and finish times as absolute numbers instead of dates | benson.wallace | Project | 2 | 12-05-2010 07:22 AM |