Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-29-2018, 02:47 AM
RunningDuck RunningDuck is offline Using COUNTIF to give start and finish times on staff schedule. Windows 10 Using COUNTIF to give start and finish times on staff schedule. Office 2016
Novice
Using COUNTIF to give start and finish times on staff schedule.
 
Join Date: Apr 2018
Posts: 1
RunningDuck is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 04-30-2018, 05:01 AM
NBVC's Avatar
NBVC NBVC is offline Using COUNTIF to give start and finish times on staff schedule. Windows 10 Using COUNTIF to give start and finish times on staff schedule. Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

Can you attach a workbook with your plan?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using COUNTIF to give start and finish times on staff schedule. 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
Using COUNTIF to give start and finish times on staff schedule. Milestones with different start and finish dates ketanco Project 2 09-17-2014 05:21 PM
Using COUNTIF to give start and finish times on staff schedule. Team Planner-maintaining accuracy in task start and finish times david_23 Project 9 04-19-2012 08:33 AM
Using COUNTIF to give start and finish times on staff schedule. displaying start and finish times as absolute numbers instead of dates benson.wallace Project 2 12-05-2010 07:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:01 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft