ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Need some assistance (https://www.excelbanter.com/excel-worksheet-functions/54917-need-some-assistance.html)

mjman15

Need some assistance
 

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



All times are GMT +1. The time now is 02:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com