In this function what is are the working hours being considered. In case it 24X7 working hours does this function suitable for use or there is some other function.Do we have the fexibility to decide the working hours in this function.
In this function what is are the working hours being considered. In case it 24X7 working hours does this function suitable for use or there is some other function.Do we have the fexibility to decide the working hours in this function.
Problem:
Calculating the number of hours between Date1 (A2) and Date2 (B2), excluding weekends.
Solution:
Use the NETWORKDAYS and MOD functions as shown in the following formula:
=NETWORKDAYS(A2,B2)-1-MOD(A2,1)+MOD(B2,1)
This formula is not working for me... Anyone else have the same issue?
Me sumo a la pregunta...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks