AndyGFLees
New Member
- Joined
- Feb 19, 2016
- Messages
- 36
Hi,
This is a simplified version of what I am trying to do:
** Spreadsheet being amended **
You can see that this is a time recording spreadsheet for visits to clients. To summarise, on day 1 the technician visits a client, selects the client name from a dynamic drop down list, enter the start and leave times, and then either continues onto any other client, or end the day.
I have finally given up trying to calculate some period reporting information, shown in the far right table. My difficulty is when coming across 3 situations - the technician may visit the same client twice in the same day, the technician may visit only 1 client on one day, but up to 5 on the next day, and the technician may visit the same client on more than one day.
For info, the cells in Green are data entry for the technician, the cells in yellow are read only for the technician, the cells in red are hidden. The tables in red at the bottom of each day are just what I think might be a temporary stage in providing my Period 1 table. I am happy to use as many hidden cells as necessary to achieve the results for my Period 1 table.
Any help would be greatly appreciated - I have gone formula blind !!.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
This is a simplified version of what I am trying to do:
** Spreadsheet being amended **
You can see that this is a time recording spreadsheet for visits to clients. To summarise, on day 1 the technician visits a client, selects the client name from a dynamic drop down list, enter the start and leave times, and then either continues onto any other client, or end the day.
I have finally given up trying to calculate some period reporting information, shown in the far right table. My difficulty is when coming across 3 situations - the technician may visit the same client twice in the same day, the technician may visit only 1 client on one day, but up to 5 on the next day, and the technician may visit the same client on more than one day.
For info, the cells in Green are data entry for the technician, the cells in yellow are read only for the technician, the cells in red are hidden. The tables in red at the bottom of each day are just what I think might be a temporary stage in providing my Period 1 table. I am happy to use as many hidden cells as necessary to achieve the results for my Period 1 table.
Any help would be greatly appreciated - I have gone formula blind !!.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
Last edited:
