Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting cells that have a time
Hello,
I'm creating a spreadsheet to come up with an employee schedule. I've gotten the basics down. I'm able to calculate the hours worked per week and per day. What I'd like to do, to really make it easier to work with going forward is to be able to count the number of staff scheduled for any given shift, based on start time. I've only got basic excel knowledge and this seems to be beyond my ability to figure out. I've tried searching here and other places, but just can't seem to find a solution. Hopefully someone here can assist me. Are attaching excel files here frowned upon? It doesn't seem to be an option. I can zip it if that helps. Thank you!! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting cells that have a time
Hi,
Am Wed, 26 Feb 2014 16:45:47 +0000 schrieb Petteri: I'm creating a spreadsheet to come up with an employee schedule. I've gotten the basics down. I'm able to calculate the hours worked per week and per day. What I'd like to do, to really make it easier to work with going forward is to be able to count the number of staff scheduled for any given shift, based on start time. you can attach a zipped excel workbook If your times are in column B and you want to count the time 8:00 try: =COUNTIF(B1:B100,TIME(8,,)) If your names are in column A and time in B you can also try for existing names at 8:00 =SUMPRODUCT(--(B1:B100=TIME(8,,)),--(A1:A100<"")) Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
|
|||
|
|||
Thanks,
I solved it with a combination of COUNTIFs like this: =COUNTIF(D4:D7,"12:00")+COUNTIF(D17:D25,"12:00")-COUNTIF(D17:D25,"19:00") Thanks again! Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting cells within certain time frames - 24 hour clock | Excel Discussion (Misc queries) | |||
Counting Time | Excel Discussion (Misc queries) | |||
Counting time | Excel Worksheet Functions | |||
Counting Time | Excel Worksheet Functions | |||
Counting Cells with time value | Excel Discussion (Misc queries) |