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.
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:
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.
[Sulprobil] [Get it done] [Organisation] [IT] [Controlling] [Human Resources] [Family] [Contact] [Download] [Disclaimer]