Need to Calculate TAT & Daily Working Hours as per working Days

[@tul]

Hi All,

Hope you doing well.

Looking support to complete my daily working Task which currently doing manually want to automated by excel formula.

Sample sheet is attached with my question.

Please help me out on this position.

Thanks

 

[vletm]

@@Tul
... and Your TAT is https://en.wikipedia.org/wiki/Tat
... and nobody haven't work ... empty list
or is this some kind of plan for working?

 

[@tul]

@@Tul
... and Your TAT is https://en.wikipedia.org/wiki/Tat
... and nobody haven't work ... empty list
or is this some kind of plan for working?

Hi,

Thanks for concern.

I am attaching sheet with same manually working that.

TAT=126 hours
Working Day =13 (bcoz 19,26 is sunday and 21 is define holiday)
Daily Working is 9 Hours so I put manuualy in every cell that I want to Automated.

Thanks

 

[Raviprmr]

Hi please find below file that will help. for each date enter the hours worked and it will calculate automatically

 

[vletm]

@@Tul
TAT = 126 ... means that TOTAL hours have to be always 126
and You would like to automatic solve those days working hours
and later You could change any days working hours as [U4] to 18hrs.
Also take care of Holidays and Sundays - no planned working!