I found some help in another post which brought me a bit closer to the result I am looking for. I need to calculate business hours between 2 dates. I am using a formula that I found on the site which excludes weekends, which is one piece of it, but I also need to know how to modify this formula even more to show a start time and a cutoff time.
This is the formula I am using:
=NETWORKDAYS(A2,B2)-1-MOD(A2,1)+MOD(B2,1)
*** This is the dilemma, lets say that the business hours are from 7a-6p, so if something was submitted after 5pm, I wouldn't want the time to be calculated until the beginning of the next working day. ** Is this possible?
Ex. 3/27/2006 17:22 - 3/28/2006 8:24 would show 15:02 as the result. But because of the time this was submitted, I would want the time to start from 7a on 3/28/06. So in actuality, I would want the result to be 1:24.
Bookmarks