JoeUser2004i thinkBob_m_mwanted a formula to calculate the END time not how much time is in between 2 values. Here is my formula (that works on older excel): =IF(E6+6/24<=INT(E6)+$D$3,MAX(E6,INT(E6)+$E$3)+6/24,$E$3+1+6/24-$D$3+MIN(E6,...
Calculating working hours By Niek Otten in forum Excel Formulas & Functions Replies: 6 Last Post: 09-06-2005, 06:05 AM Calculating working hours By John in forum Excel Formulas & Functions Replies: 3 Last Post: 07-01-2005, 01:05 AM Tags for this Thread sla calculation View ...
SLA - 6 Hrs from Registered Date & Time JoeUser2004i thinkBob_m_mwanted a formula to calculate the END time not how much time is in between 2 values. Here is my formula (that works on older excel): =IF(E6+6/24<=INT(E6)+$D$3,MAX(E6,INT(E6)+$E$3)+6/24,...
i thinkBob_m_mwanted a formula to calculate the END time not how much time is in between 2 values. Here is my formula (that works on older excel): =IF(E6+6/24<=INT(E6)+$D$3,MAX(E6,INT(E6)+$E$3)+6/24,$E$3+1+6/24-$D$3+MIN(E6...
=IF(E6+6/24<=INT(E6)+$D$3,MAX(E6,INT()+$E$3)+6/24,$E$3+1+6/24-$D$3+MIN(E6,INT(E6)+$D$3)) and using the newer LET: =LET(in,E6,delay,6/24,dEnd,$D$3,dStart,$E$3,d,INT(in),h,in-d,freeze,1-dEnd+dStart,IF(h+delay...
mtarlerwrote: ``i think@Bob_m_mwanted a formula to calculate the END time not how much time is in between 2 values`` I concur. I totally misread the original posting. I will delete my response (misdirection). FYI, the "exhaustive" test cases that I provided are at ...
Excel one cell formula for calculating Actual SLA End date & time Criteria 22:00 - 08:00 - Freezing time SLA - 6 Hrs from Registered Date & Time =