Ok im doing up a timesheet (but much fancier then most out there)

Ok what im trying to do is schedule people to do a task...so i need a
function or functions that will do this..

Look for a certain time (lets say 9:00 AM) Then go over to Colum A pull
there name and print it in the cell block

ExP.

NAME START END HOURS WORKED

JOE 2:00 am 6:00 am 4.5 HRS
BILL 5:00 am 10:00am 5 HRS


Check for uncompleted job orders: (need a function that will look
at who is scheduled at 2:00 am and print his name here) so it would
look like this

Check for uncompleted job orders: JOE


Any help would be GREATLY appricated!


--
mjman15
------------------------------------------------------------------------
mjman15's Profile: http://www.excelforum.com/member.php...o&userid=28720
View this thread: http://www.excelforum.com/showthread...hreadid=484129