View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
clinton.holder
 
Posts: n/a
Default creating an hourly matrix (scheduling)


Could anyone walk me through the functions needed for creating a matrix
that would look at a schedule worksheet and tell me the number of
people that are working at a specified time? Say I have a full
schedule, I want it to do similar to a tally for every hour like how
many people working at 04:30, then how many people working at 05:00 and
so on? I think it would be something to do with the COUNTIF function but
I'm not sure syntax.


--
clinton.holder
------------------------------------------------------------------------
clinton.holder's Profile: http://www.excelforum.com/member.php...o&userid=30427
View this thread: http://www.excelforum.com/showthread...hreadid=500934