I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

sbCountHours

If you need to count hours (accurate to minutes and seconds) between two date/time entries (and if you need to take holidays into account) and you only want to count specified time slots per weekday, you can use my UDF sbCountHours. If you want to add hours to a date/time entry and only counting specified time slots per weekday, you can use my UDF sbAddHours:

20101010_PB_01_sbCountHours_Screen
sbCountHours_01_Code
sbCountHours_02_Code
sbCountHours_03_Code
sbCountHours_04_Code

If you are interested in downloading an Excel 2010 sample file with the source code of both VBA functions, go to my Download page, please.

sbAddHours_Code_01
sbAddHours_Code_02
Sulprobil   Get it done   Contact   Disclaimer   Download