MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Time@#$@%#&^*&#


Posted by Seal on January 07, 2002 7:06 PM

I always get frustrated when working with time! I have a list of names and there shift beginning and ending times. I want to know how many are on the job at any given hour of the day. I have a sheet I can send anyone with ideas for this if you email me and I'll send it.


Posted by Aron on January 07, 2002 10:12 PM

Assuming the range containing start times is named 'Start' and the End times 'End', and '1's in the Range called 'Include.' Also, 24 cells containing hours (0-23) in C2:C26. (As set up on your sheet.)

Enter the following formula cell C2:

=SUM(IF(C2>=Start,IF(C2<End,Include)))

...and then hit Control+Shift+Enter ('CSE') for an array formula. Then you can drag this formula across the rest of the cells under the hours.

Hope this helps!
Aron

Posted by Seal on January 07, 2002 11:59 PM

Works Great Aron!!!
Thanks for your help.

ken
;)