Calculate Working Hours in VBA

Tuesday, June 24th, 2008 3,284 views

In the spirit of my last post Calculate Working Days Minus Holidays in VBA, here is a function I wrote recently that returns the number of working hours between two date/time values passed to the function as arguments. It is self-contained and works independently of whatever existing code you have, ...

Posted in Excel, UDF, VBA | 9 Comments »

Calculate Working Days Minus Holidays in VBA

Tuesday, June 17th, 2008 2,109 views

I was looking for a function that calculates working days, minus holidays, for a small project I've been working on. I decided to write one myself, but below I've also demonstrated an alternate way that uses the ATP (Analysis ToolPak) functions for VBA.   [vba] Function WorkDays(StartDate As Variant, EndDate As Variant) ...

Posted in Excel, UDF, VBA | 3 Comments »

Wordpress move almost complete!

Tuesday, June 10th, 2008 15 views

Dear Readers, If you are reading this that means I didn't completely blow it - this blog is now on a Wordpress adventure! Please bear with me as I work out the kinks over the next few days, for example the theme is terrible, but it's the only one I could ...

Posted in administrative | No Comments »

Moving to Wordpress

Monday, June 9th, 2008 28 views

So I finally got enlightened and decided to move the blog to Wordpress. I'll be moving all of the posts over to the new blog located atCode For Excel And Outlooksome time in the next few days. And I'll attempt to keep the Feedburner feed going as well. Right now ...

Posted in administrative | 3 Comments »