Turn Around Time Tracker

[call2shree]

Hi Experts

Need your help to create a tracker to check the status of task completion. Please check below heads need to consider.


A1 :Receive date& time

B1: Completion date & time

Weekdays : Mon -Fri

Working hours: 9 (17.00-2.00)

Holidays

Formula should exclude weekends(Sat&SUN) and apart from working hours

based on the above details need to consider to fine the completion in days, hour,mintue manner.



Thanks in Advance

Srinath

 

[NARAYANK991]

Hi Srinath ,

You might have seen a banner by Hui which suggests something that users should do when posting new threads. Please follow that advice.

Narayan