I have decided that i hate all time sheets
Too many with multiple entries in one cell
Requirements to cf all sorts of things
Dates entered as text
Merged cells
Times entered in stupid formats
There rant over!
I have decided that i hate all time sheets
Too many with multiple entries in one cell
Requirements to cf all sorts of things
Dates entered as text
Merged cells
Times entered in stupid formats
There rant over!
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I hate them too and I don't bother anymore even to look at them.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)
haha j/k. yup I hear you. I have no great love of working with times anyway
Last edited by FDibbins; 07-10-2014 at 05:58 PM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I think the biggest (most annoying) problem is that people have a really good idea of how they want their timesheets to look but if they know how they want them to work then they don't really need to post questions on the forum in the first place.
So it's a bunch of excel-newbies with very particular demands that don't understand how hard their badly-laid-out but nice-looking table-dashboard-hybrids are to use.
They're never very interesting questions where you feel clever solving it; it's just a formatting slog.
And the goalposts move really easily.
Every new generation of office worker needs to be taught all over again that form follows function, way too many times they approach from the opposite... and we help. (fail)
It's on us to politely point out the problem with the approach and offer correction to their process, then walk away calmly when they refuse. Timesheets... what an excellent model of this very problem. I echo your sentiments about them.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks