LinkBack URL
About LinkBacks
Hello Donna,
That formula will only work when the start and end times are within the working hours. Try this formula that should work for any start/end times
=(INT(B2)-INT(A2))*(D2-C2)+MEDIAN(MOD(B2,1),D2,C2)-MEDIAN(MOD(A2,1),D2,C2)
Hello Donna,
That formula will only work when the start and end times are within the working hours. Try this formula that should work for any start/end times
=(INT(B2)-INT(A2))*(D2-C2)+MEDIAN(MOD(B2,1),D2,C2)-MEDIAN(MOD(A2,1),D2,C2)
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks