Time Computation

[Archie077]

Hello EveryOne,

I am trying to create a formula out of this logic

*Logics

1. Working Hours = 9am to 6pm

2. Beyond 6pm but before 10am the next day, completion time is 0

START DATE	END DATE	COMPLETION TIME (SHOULD BE COMPUTED WITH IN THE TIME FRAME OF 9AM - 6PM
08/03/2020 15:20	08/04/2020 7:34
08/12/2020 18:17	08/13/2020 08:16
8/15/2020 07:00	8/15/2020 10:00

Thank you

[#2]

Dear @Archie077 I think Estimated Time To Complete (ETC) in Excel could be useful in this case. However, take a look on it: https://www.uky.edu/~dsianita/300/schedule.html It could be helpful.