Excel Formula to Subtract Time with Conditions

[tmohler]

Hello Everyone,

Hopefully some can help provide some guidance and/or solution.

I am trying to create a formula to subtract the receipt date/time from arrival date/time. Have a condition with in the formula to subtract non operating time on Friday, Saturday, and Sunday. Conditions would be based off any cell difference greater than 24 hours. Example is attached.

Main formula

=IF(E2<1,E2,IF(A2="Friday",AND(E2>0.98,E2-0.31,IF(A2="Saturday",AND(E2>0.81,E2-0.48,IF(A2="Sunday",AND(E2>0.81,E2-1.15,C3)))))))

Thank you for your help and support

Theo

 

[tmohler]

Sorry for the extra reply below is what was used in the formula to subtract the time

Friday	7/12/2023 23:30​	Saturday	7/13/2023 7:00​	0.31​	7:30​
Saturday	7/12/2023 19:30​	Sunday	7/13/2023 7:00​	0.48​	11:30​
Sunday	7/12/2023 19:30​	Sunday	7/13/2023 23:00​	1.15​	3:30​

 

[tmohler]

Hello Everyone,

Just following up to see if anyone has a possible solution.

Thanks,