8 Hours TAT Calculations

DurgaGireesh

New Member
Joined
May 30, 2018
Messages
9
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

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,504
Office Version
2010
Platform
Windows
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
Joined
May 30, 2018
Messages
9
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
Joined
May 30, 2018
Messages
9
Hi Rick,

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

<tbody>
</tbody>
 

DurgaGireesh

New Member
Joined
May 30, 2018
Messages
9
Hi Rick,

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

Sample IDAssigned ToSubmitted DateTypeFinal TAT Time
123456California6/1/2018 7:24SA

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

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,504
Office Version
2010
Platform
Windows
Hi Rick,

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

Sample IDAssigned ToSubmitted DateTypeFinal TAT Time
123456California6/1/2018 7:24SA

<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?
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,504
Office Version
2010
Platform
Windows
Thats an example.
:confused: 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).
 

Forum statistics

Threads
1,082,126
Messages
5,363,320
Members
400,725
Latest member
excelingtolearn

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top