Waiting List Template Excel

[Referral Date] 01/01/2010 [Date Of First Appointment] 10/01/2010 [Waiting Time] 9 Days Would Be Very Grateful For Any.

The block is then copied and the values pasted onto another worksheet. Here the patients are supposed to be listed if they're not already served, which would be noted as a 1 in column c, e or g. So the task, that i am unable so solve is to list all the patients that have a 0 next to. My first issue is how i can use excel to do a linear calculation and optimizing a cutting list for least waste, below is an example :

And If They Are Not On The Waiting List Then I Would Like The Cell To Remain Blank.

Hello, i'm trying to use an excel file to do a waiting list. I need a formula that will calculate the total waiting time from the date of a patient's referral to the date of the patient's first appointment and display the value in days. Hi there, i would like a formula in column l to calculate the waiting time of patients who are on the waiting list (column h with a 1). Basically, the problem is just to put the time (i.e in a5) at the moment when.

Thanks For The Help Sophy

We need a printable, easy to read list (worksheet 2) based on data (worksheet 1) for the use of staff and volunteers. In one of the cells, i would like to automatically put the time when the customer come in (with a format like hh:mm). My assignment is to create an excel spreadsheet that would list the employee's name in a the first column and then allow me to put the date in the adjacent column which would automatically move the person's name to the bottom of the list. Hello chaps, i'm in a spot of bother.

Hi, I Am Trying Desperately To Teach Myself Excel.

As this is part of a larger workbook i have the calculations set to manual. I have a loop with 3 web queries that are brought into a renamed copy of a template worksheet. The waiting list is b14:g24. A block of formulas on the renamed worksheet are suppose to update.