Forum Discussion
Calculating hours
Since you have created a starter spreadsheet, would you be willing to share that? (Doing so would make it easier by far to create and test a solution for you.)
In creating a message or posting on this forum, you should see something like this below the box into which you type. Just drag and drop the spreadsheet into that area that asks for it. If you cannot do this, put a copy on OneDrive or GoogleDrive and paste a link here that grants access to it,
That said, may I ask a question or two:
- Is this layout one that you use for each of your clients, with some of them requiring only 1:1 services; others (like this example) requiring 2:1?
- Do you have a separate tab for each client?
- Do some clients require an occasional 3:1 service (or any other variation)?
- Are the three shifts shown constant for all clients?
- Do some clients require services for only one or two shifts?
- Finally, would you be willing to consider a different layout?
The purpose of those questions, in case you're wondering: in designing spreadsheet solutions, it's my experience that one can always do a better job with a complete understanding of "the big picture." Hence I often ask more questions rather than just giving a simple answer to the "presenting question." [I'm sure you do the same with your clients.]
I am trying to attach the document but it does not allow .xlsx format. I will try and link it but I'm also having trouble with that.
- Is this layout one that you use for each of your clients, with some of them requiring only 1:1 services; others (like this example) requiring 2:1?
Only a few clients are 2:1. Not all.
2. Do you have a separate tab for each client?
There is a separate tab for each client.
3. Do some clients require an occasional 3:1 service (or any other variation)?
We do not have any 3:1 clients as of now.
4. Are the three shifts shown constant for all clients?
Some have up to 6 shifts. It could be anywhere from 1 shift to 6 shifts for 1 client.
5. Do some clients require services for only one or two shifts?
No
6. Finally, would you be willing to consider a different layout?
Yes
I am trying to attach the document but it does not allow .xlsx format.
It absolutely allows xlsx files to be attached. Down here, below the text box where you write your inquiry. You do need to click on "Open full text editor" to see it, but rest assured that xlsx files ARE allowed on the Excel tech community board!
And if you still can't, then go and put the file on OneDrive or GoogleDrive and paste a link here that grants access.
Thanks for the answers to the other questions, but it will be essential to see the file.
And while you're at that, since there are sometimes up to six shifts, it would be very helpful if you could include, either in that posted spreadsheet or in a text description, a complete description of how the shifts break down in terms of hours. The three shifts appear to be very consistent in terms of their start and stop times; are they? And hopefully the six shifts would be similarly consistent.
It is attached! I was trying to drag it and it just wasn't working. Thanks.
Please use week 8/25 and 9/1. The past weeks are not updated with formula changes.
Jordan Bushman is an example of a 2:1 client.
