Excel icon

Calculate Working Hours in VBA

(Update 3/25/2009: See Time Difference Testing for an updated version of the code found below.)

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, so it is a true "drop-in" code you can use anywhere you need it.

Continue Reading: Calculate Working Hours in VBA »

Excel icon

Calculate Working Days Minus Holidays in VBA

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.

Continue Reading: Calculate Working Days Minus Holidays in VBA »

Site last updated: February 9, 2012