8 Hours TAT Calculations

[DurgaGireesh]

Hi Experts,

i want to calculate 8 hour TAT

Senerio:-Working Hours 8:00:00 Am to 5:00:00 PM and Sat and Sunday Week off

if i received one file at May/30/2018 9:30:00 AM for this we should calculate 8 hours TAT (Ex:-i have received one file at May/30/2018 9:30:00 AM for this file tat is next day May/31/2018 8:30:00 AM is end time).currently iam doing manully i need formula for this senerio.

 

[Rick Rothstein]

if i received one file at May/30/2018 9:30:00 AM for this we should calculate 8 hours TAT (Ex:-i have received one file at May/30/2018 9:30:00 AM for this file tat is next day May/31/2018 8:30:00 AM is end time).currently iam doing manully

How is your date laid out? Is the date and time all in one cell or split between two cells?

Whichever it is, tell us the column or columns they are in.

Also tell us how the answer should be laid out... all in one cell or split between two cells.

 

[DurgaGireesh]

Hi Ricks,

i will capture received time and date manully so for that i need to calculate 8 hours tat so i need end time .

 

[DurgaGireesh]

Hi Rick,

Below listed is the format. I need this in the same column.
[TABLE="width: 166"]
<tbody>[TR]
[TD="class: xl65, width: 166"]6/1/2018 10:09[/TD]
[/TR]
</tbody>[/TABLE]

 

[DurgaGireesh]

Hi Rick,

We need a formula. Below listed is the tracking system which we follow.

[TABLE="width: 649"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Sample ID[/TD]
[TD]Assigned To[/TD]
[TD]Submitted Date[/TD]
[TD]Type[/TD]
[TD]Final TAT Time[/TD]
[/TR]
[TR]
[TD]123456[/TD]
[TD]California[/TD]
[TD]6/1/2018 7:24[/TD]
[TD]SA[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[Rick Rothstein]

Hi Rick,

We need a formula. Below listed is the tracking system which we follow.

[TABLE="width: 649"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Sample ID[/TD]
[TD]Assigned To[/TD]
[TD]Submitted Date[/TD]
[TD]Type[/TD]
[TD]Final TAT Time[/TD]
[/TR]
[TR]
[TD]123456[/TD]
[TD]California[/TD]
[TD]6/1/2018 7:24[/TD]
[TD]SA[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

You said your working hours are 8am to 5pm, but your example shows you receiving the file before the start time. Should the 8 hour turn-around be calculated from 8am for such a file?

 

[DurgaGireesh]

Hi Ricks,

Thats an example.

 

[Rick Rothstein]

Thats an example.

I know it was an example, but I don't know how to handle it which is why I asked my question. The reason I had to ask my question is because I, as well as the other volunteers in this forum, know absolutely nothing about your work or its requirements. If you don't tell us what we need to know to answer your question, we ask follow up questions of our own. If you do not answer them in detail, then we will still not know how to answer your question. So, with that said, please go back to Message #6 and read my question again and then answer it (otherwise I will not be able to help you).