Jan 23 2009, 06:36 AM
In the attached file can someone tell me if its possible to calaculate total hours by a particualr member of staff by referencing the Staff Fields and the Hours Fields. I dont think its possible but thought I would ask here. If not can someone advise on the best way to go about recreating this excel sheet to support what we need to do.
Any advice much appreciated.
Jan 23 2009, 07:33 AM
I think your main issue here is that you have more then one staff member listed in the staff cells for each topic. I really think this should be transitioned to an Access database in which case you'll find what you want to do much easier.
Jan 23 2009, 08:01 AM
That was my belief too. I have a real job on trying to move users away from their spreadsheets.
I know now its development time and they just wont use it.
THanks for your reply.
Jan 24 2009, 01:59 PM
The formula would be really quite complicated, as you may have multiple entries not only in the staff cell, but even in the hours cell. The decimal point ( dot) makes it even more difficult for international environment...
You might be better off with an UDF (written in VBA).
Is the answer for DA: 9 and for JM: 1.5 for the first group? If not, what should be the result?
Feb 12 2009, 10:20 AM
I've told them the options and they want to keep their spreadsheet.
Just as I suspected.
Feb 12 2009, 10:53 AM
That is fine. I just wanted to say that it's better to write a function in VBA for this purpose, as the formula would be relatively complicated and hence difficult to edit.
Can you give examples of the desired results (as I have asked in my last post?)
Feb 16 2009, 01:32 PM
Yes the answer is 9
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here