I have been searching through posts for the past hour trying to find information on doing the following and can't quite find what I need:
I have Date In, Time In, Date Out and Time Out fields in a table
I need to calculate the number of hours it took to process between date/time in and date/time out
I have VBA code working to calculate number of days and not include weekends and holidays.
When calculating the time difference and only include between 8am and 5pm
I'm having trouble figuring out how to calc the time if it goes over multiple days
Thought if anyone had already done this I wouldn't try to reinvent the wheel!