Calculate Hours Between Dates (Excel Function)

Category:
Office/VBA
Type:
Snippets
Difficulty:
Beginning

Author: Patrick

Version Compatibility: Visual Basic 6, Visual Basic 5, Visual Basic Script

More information:
This is a simple EXCEL function that calculates the Business Hours between two dates. The math and concepts are pretty basic and should be portable to any platform. I'm not a programmer, so suggestions (be nice) would be appreciated.

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:

Code: