Forum

elf_peace
@elf_peace
Active Member
Joined: Nov 29, 2016
Topics: 1 / Replies: 2
Reply
RE: Formula to add hours in Specific date and time range in Excel

Ok please refer to attachment. I want to find formula for fix time in column (H12,I12,J12,K12,L12 & M12). The result should be appear once I in...

8 years ago
Reply
RE: Formula to add hours in Specific date and time range in Excel

Hi Derek Brown, Thanks for reply. formula given is almost similar with what I'm currently used. =WORKDAY(A1,CEILING((B2+MOD(A1,1)-P6)/(R6-P...

8 years ago