Time Computation

%3CLINGO-SUB%20id%3D%22lingo-sub-1626888%22%20slang%3D%22en-US%22%3ETime%20Computation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1626888%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20EveryOne%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20a%20formula%20out%20of%20this%20logic%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*Logics%3C%2FP%3E%3CP%3E1.%20Working%20Hours%20%3D%209am%20to%206pm%3C%2FP%3E%3CP%3E2.%20Beyond%206pm%20but%20before%2010am%20the%20next%20day%2C%20completion%20time%20is%200%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22346%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22111%22%3ESTART%20DATE%3C%2FTD%3E%3CTD%20width%3D%22111%22%3EEND%20DATE%3C%2FTD%3E%3CTD%20width%3D%22124%22%3ECOMPLETION%20TIME%20(SHOULD%20BE%20COMPUTED%20WITH%20IN%20THE%20TIME%20FRAME%20OF%209AM%20-%206PM%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E08%2F03%2F2020%2015%3A20%3C%2FTD%3E%3CTD%3E08%2F04%2F2020%207%3A34%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E08%2F12%2F2020%2018%3A17%3C%2FTD%3E%3CTD%3E08%2F13%2F2020%2008%3A16%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E8%2F15%2F2020%2007%3A00%3C%2FTD%3E%3CTD%3E8%2F15%2F2020%2010%3A00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1626888%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1627746%22%20slang%3D%22en-US%22%3ERe%3A%20Time%20Computation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1627746%22%20slang%3D%22en-US%22%3EDear%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F756671%22%20target%3D%22_blank%22%3E%40Archie077%3C%2FA%3E%20I%20think%20Estimated%20Time%20To%20Complete%20(ETC)%20in%20Excel%20could%20be%20useful%20in%20this%20case.%20However%2C%20take%20a%20look%20on%20it%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.uky.edu%2F~dsianita%2F300%2Fschedule.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.uky.edu%2F~dsianita%2F300%2Fschedule.html%3C%2FA%3E%20It%20could%20be%20helpful.%3C%2FLINGO-BODY%3E
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
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.