Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Excel TAT Calculation

0

Hi All,

i have query regarding find out the TAT calculation for the below infomation that i have

Date created

Clarification sent date

Clarification received date

Review sumbit date (end of first TAT)

Clarification Sent Date (After Review)

Clarification Received date

Final submission date

Working Hours 9AM to 6PM. if a ticket was create in between working hours that should be completed within a EOD. if it was created after 4 PM (cutoff) the TAT should be completed on the next EOD

If we have sumit any clarification within working hours and receive a clari after 4PM the TAT should be completed on the next EOD

Totally i need two TAT. one is review submit & final submit. if both are met the TAT. the final TAT should be met. otherwise Not Met.

Please advise on this...

Answer
Discuss

Discussion

What is your question?
Variatus (rep: 4889) Dec 10, '18 at 7:15 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login