Re: $$Excel-Macros$$ Calculate Business Hours exluding weekends and holidays with a caveat

2012-12-18 Thread Timothy Kluck
e good you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *- > > > -

Re: $$Excel-Macros$$ Calculate Business Hours exluding weekends and holidays with a caveat

2012-12-18 Thread Timothy Kluck
gt; In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *--------- > > > -- > *From:* Timothy Kluck >

Re: $$Excel-Macros$$ Calculate Business Hours exluding weekends and holidays with a caveat

2012-12-17 Thread Timothy Kluck
places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *- > > > -- > *From:* Timothy Kluck > > *To:* excel-...@googlegroups.com > *Sent:* Fri, December 14, 2012 4:19:45 PM > *Subject:* Re: $$Excel-

Re: $$Excel-Macros$$ Calculate Business Hours exluding weekends and holidays with a caveat

2012-12-14 Thread Timothy Kluck
es you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *- > > > -- > *From:* Timothy Kluck > > *To:* excel-...@googlegroups.com > *Sent:* Fri, Dece

Re: $$Excel-Macros$$ Calculate Business Hours exluding weekends and holidays with a caveat

2012-12-14 Thread Timothy Kluck
want to approach this? > > > *Paul* > > - > *“Do all the good you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as

$$Excel-Macros$$ Calculate Business Hours exluding weekends and holidays with a caveat

2012-12-14 Thread Timothy Kluck
Hi all, I have been really struck trying to find a formula to calculate business hours between 2 dates, especially if it is started on a weekend and ending on a weekend. I have attached an excel spreadsheet with certain dates, and the answers that I am looking for. I have also attached a holid