After reading some of the comments on Calculate Working Hours in VBA, I went back and reworked the TimeDiff function. Below is the new and improved WorkingHoursDiff function!
Continue Reading: Time difference testing »
Calculate Working Hours in VBA
June 24, 2008 by · 
(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 »
Follow Me