elf_peace
Active Member
Joined: Nov 29, 2016
Follow
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
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
Replies: 6
Views: 171