Turn Around Time Calculation

[DonSlayer]

Hi! I am stuck and needs some help/feedback.


I am working on a turnaround time frame calculator to include weekends. I worked through some other threads to see if I could do it and I am having a disconnect. I started with this, and added in the following formula:

=24*NETWORKDAYS.INTL(A3,C3,1,$G$4)+((D3-B3)*24)

Can someone help me see what step I am missing in this process?

 

[johnny51981]

This seems to work for me.

=TEXT(C2+D2,"mm/dd/yyyy hh:mm:ss am/pm")-TEXT(A2+B2,"mm/dd/yyyy hh:mm:ss am/pm")

 

[DonSlayer]

Thank you for your help!
I added the formula you listed above, and this is the end result. how can I make it display total hours?

 

[Asbestos_Jen]

This formula is simpler and works. Format the TAT cell as [h]:mm:ss (square brackets required).

Book1
	A	B	C	D	E
1	Date Recd	Time Recd	Date Compl	Time Compl	TAT (H)
2	03-01-24	08:26:11	05-01-24	10:11:36	49:45:25
3	03-01-24	14:15:36	05-01-24	14:45:13	48:29:37
Sheet1

Cell Formulas
Range	Formula
E2:E3	E2	=(C2+D2)-(A2+B2)

 

[Asbestos_Jen]

If you need to exclude holidays, weekends, and non-work hours, check out this post:

Working Hours Taken to Complete a Task

I'm trying to calculate the amount of time taken to complete a task. The data I receive is a date/time stamp format. I'm wanting to establish how many working hours & minutes it takes to complete each task. I've been googling and trying different things for about 6 hours now, and I can't seem...

www.mrexcel.com

 

[DonSlayer]

I think I got it! Does this look right? =(C2+D2)-(A2+B2)

 

[Asbestos_Jen]

I get the same results.

2024-10-03.xlsx
	A	B	C	D	E
1	Date Recd	Time Recd	Date Compl	Time Compl	TAT (H)
2	3-Jan-24	8:26:11 AM	5-Jan-24	10:11:36 AM	49:45:25
3	3-Jan-24	2:15:36 PM	5-Jan-24	2:45:13 PM	48:29:37
4	29-Aug-24	3:38:44 PM	30-Aug-24	9:56:48 AM	18:18:04
5	29-Aug-24	3:38:44 PM	4-Sep-24	3:25:02 PM	143:46:18
Sheet1

Cell Formulas
Range	Formula
E2:E5	E2	=(C2+D2)-(A2+B2)

 

[Alex Blakenburg]

The above gives you hours minutes and seconds. So just remember that if you want it in Hours and fraction of an hour to multiply the result by 24 and change the format to a number format (not the duration format)