Formula to get Turn around time of an activity.

[Raj2711_excel]

Hi all,


Please help ! I need a formula to calculate Turn Around Time for an activity. The scenario is,

Start date & time: 21/12/2015 11:00 AM
End Date & Time: 30/12/2010 12:00 PM
Working Hours: 11:00 AM to 8:30 PM
Weekdays: Monday to Friday
Weekends: Saturday & Sunday
The Formula should consider holiday list while calculating the TAT.

Say for example, if the activity continues to extend for days the output i.e TAT should be in days & hours.

Please help and let me know if you need any details

Thanks !!!!

[Glenn Kennedy]

Hi. the formula is fairly lengthy... as you can see. B1 - start date/time; B2 - End date/time
B3 -Working Day start; B4 - Working day end; Holidays G1:G4

Please Login or Register  to view this content.

[samba_ravi]

see the attached file

[Raj2711_excel]

Hi Siva,

Thanks for the formula. the Formula provided by Glen seems more helpful, even though it was bit lengthy, it was the right solution for the use case that I mentioned.