Mind Gone Blank!!
My wife has asked me to create a sheet that will give her the following
info. She works in a store with a number of checkouts. The sheet will have all her staff start times and finish times. This will be inputted every day. Excel will then create another sheet that will show the time of the day at 30 min intervals how many checkout staff is on at that time. Nothing too fancy, I have been sitting here for two hours trying to figure this one out. I have a screenshot of the info if anyone wants it if I'm not clear enough. newsgroup @ mmillar . co . uk delete the spaces to reply! thanks folks -- Regards M Millar |
Mind Gone Blank!!
Try this: Column A: Name Column B: Start Time Column C: End Time Column D, Row 1 8:00 Column D, Row 2 8:30 Column D, Row 3 =AND(D$1=$B3,D$2<=$C3) Column D, Row 100: =Countif(D3:D99,"=TRUE") -- CaptainQuattro ------------------------------------------------------------------------ CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763 View this thread: http://www.excelforum.com/showthread...hreadid=537620 |
Mind Gone Blank!!
Cheers guys - Specially to the Captain, as I've now got it working. And
thanks for the pointer on the 24 hour - though she has just moved out of one to a "days only" store! -- Regards M Millar "SantaUK" wrote in message ... My wife has asked me to create a sheet that will give her the following info. She works in a store with a number of checkouts. The sheet will have all her staff start times and finish times. This will be inputted every day. Excel will then create another sheet that will show the time of the day at 30 min intervals how many checkout staff is on at that time. Nothing too fancy, I have been sitting here for two hours trying to figure this one out. I have a screenshot of the info if anyone wants it if I'm not clear enough. newsgroup @ mmillar . co . uk delete the spaces to reply! thanks folks -- Regards M Millar |
All times are GMT +1. The time now is 03:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com