Time Computation

Highlighted
New Contributor

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 DATEEND DATECOMPLETION TIME (SHOULD BE COMPUTED WITH IN THE TIME FRAME OF 9AM - 6PM
08/03/2020 15:2008/04/2020 7:34 
08/12/2020 18:1708/13/2020 08:16 
8/15/2020 07:008/15/2020 10:00 

 

 

Thank you

 

1 Reply
Highlighted
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.