ConneXionLost
New Member
Joined: Jun 25, 2016
Follow
RE: Find the Total Hours Completed
How about this: =IF(B1>B2,MIN(24-HOUR(B1),7)+MIN(HOUR(B2),7),MAX(7-HOUR(B1),0)+MAX(HOUR(B2)-17,0)) Cheers,
9 years ago