Andy Blyth Posted February 23, 2009 Share Posted February 23, 2009 Darryl try this worksheet function: Ahh much cleaner! Nested excel functions make me want to cry Link to comment Share on other sites More sharing options...
jevansio Posted February 23, 2009 Share Posted February 23, 2009 Attached is a working sample. Cell's in red are the ones you alter (note the use of the ' symbol to get it to recognise the date as text) Also note it says 38 hours as I started at 10am on Monday and finished on a Sunday, I used 8 working hours per day. It works my end, anything that doesn;t work maybe an Excel version issue, we'll take it from there Link to comment Share on other sites More sharing options...
jevansio Posted February 23, 2009 Share Posted February 23, 2009 Ahh much cleaner! Nested excel functions make me want to cry Yip, it would be possible in pure functions, just really messy, code makes it much easier to understand what's going on Darryl, if you need any part explaining giz a shout, I'm off to bed shortly but will pick it up in the morn otherwise Link to comment Share on other sites More sharing options...
jevansio Posted February 23, 2009 Share Posted February 23, 2009 Just tried this myself, there is a problem with security in the spreadsheet when playing Macros which are downloaded. To get round this drop the security level to Medium (Tools...Macros...Security) so it asks you to run untrusted macros, restart excel, and when it asks enable macros. You may want to revert that setting after testing this. If you copy & paste the macro into your own module you won't need to do that Link to comment Share on other sites More sharing options...
Homer Posted February 24, 2009 Author Share Posted February 24, 2009 Andy and Jay you are absolute legends! Thats exactly what I needed. I'm just finishing work for the day (another 17 hour one!) and need a break, but will add these into the sheet tomorrow. From what I've seen it looks like it will work perfectly Link to comment Share on other sites More sharing options...
jamesmark Posted February 24, 2009 Share Posted February 24, 2009 Dunno if this is any help to you? (Maybe not now but in the future). Not used it yet, I got it so I can teach myself Excel. Creating Spreadsheets and Charts in Microsoft Office Excel 2007 for Windows. (pdf) Link to comment Share on other sites More sharing options...
Homer Posted February 24, 2009 Author Share Posted February 24, 2009 Thats a pretty good guide for beginers to Excel and covers a lot of the basics. There are very few guides (if any) that'll get close to what I asked for (certainly couldn't find anything on google), it's one of those things that you just need to know what formula's are available to get the results, and then be able to figure the logic. Failing that you can just know your VB Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now