Excel iconTutorial icon

Excel Tutorial Series – Date and Time functions

This is part four of the Excel Tutorial Series. Read all tutorial posts by browsing the Tutorial category.

Continue Reading: Excel Tutorial Series – Date and Time functions »

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 »

Site last updated: February 9, 2012