# 8 Hours TAT Calculations

#### DurgaGireesh

##### New Member
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.

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

#### Rick Rothstein

##### MrExcel MVP
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

##### New Member
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

##### New Member
Hi Rick,

Below listed is the format. I need this in the same column.
 6/1/2018 10:09

<tbody>
</tbody>

#### DurgaGireesh

##### New Member

Hi Rick,

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

 Sample ID Assigned To Submitted Date Type Final TAT Time 123456 California 6/1/2018 7:24 SA

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

#### Rick Rothstein

##### MrExcel MVP
Hi Rick,

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

 Sample ID Assigned To Submitted Date Type Final TAT Time 123456 California 6/1/2018 7:24 SA

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
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

##### New Member
Hi Ricks,

Thats an example.

#### Rick Rothstein

##### MrExcel MVP
Thats an example.

Replies
8
Views
295
Replies
1
Views
141
Replies
27
Views
1K
Replies
1
Views
209
Replies
1
Views
63

1,129,373
Messages
5,635,884
Members
416,886
Latest member
coreyalaurence37

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back