Problem: Every day I come in to work and intend to work eight hours. If I come in at 8:30 AM, and given an hour lunch, what time do I need to leave to work exactly eight hours?
Continue Reading: Calculate Working Hours In Reverse »
Time difference testing
March 12, 2009 by · 
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