alamedablues
New Member
- Joined
- Jan 26, 2004
- Messages
- 9
Heres the scenario,
A major part of my work is to measure time. The time it takes for someone to receive health treatment or, how long the person had to wait for services, as well as how many days a person spent in treatment so that I can attached a dollar amount per day to both of these time periods.
Problem:
In the spreadsheets I'm developing there are three columns next to each other. One is "Waiting Start Date," next to that is, "Waiting End Date," and adjacent to that is "Number of Days Waiting." All of the cells in the date columns are always formatted to a date format such as January 21, 2004. The "Number of Days Waiting" column is always formatted to a number. The function I use that is not sufficient for this process is, "Waiting End Date" minus "Waiting Start Date" equals "Number of Days Waiting." Such as, =D2-C2.
This formula will only calculate number of days waiting when a Waiting End Date-DATE is typed in the cell to the right of "Waiting Start Date."
What I need is to have the days waiting begin to calculate on its own after a start date with the end date cell left open so that each day the number of days waiting changes to the next number of days almost like an automobile odometer. (I hope this explains it well.) The clock needs to shut off once a Waiting End Date DATE is typed in. This same calculation is need for "Number of Days in Tx" as well. It is that number I'll attached a dollar sign to.
A major part of my work is to measure time. The time it takes for someone to receive health treatment or, how long the person had to wait for services, as well as how many days a person spent in treatment so that I can attached a dollar amount per day to both of these time periods.
Problem:
In the spreadsheets I'm developing there are three columns next to each other. One is "Waiting Start Date," next to that is, "Waiting End Date," and adjacent to that is "Number of Days Waiting." All of the cells in the date columns are always formatted to a date format such as January 21, 2004. The "Number of Days Waiting" column is always formatted to a number. The function I use that is not sufficient for this process is, "Waiting End Date" minus "Waiting Start Date" equals "Number of Days Waiting." Such as, =D2-C2.
This formula will only calculate number of days waiting when a Waiting End Date-DATE is typed in the cell to the right of "Waiting Start Date."
What I need is to have the days waiting begin to calculate on its own after a start date with the end date cell left open so that each day the number of days waiting changes to the next number of days almost like an automobile odometer. (I hope this explains it well.) The clock needs to shut off once a Waiting End Date DATE is typed in. This same calculation is need for "Number of Days in Tx" as well. It is that number I'll attached a dollar sign to.