Forum Discussion
Time Computation
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
- 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.
