How to Calculate Turnaround Time in Excel Excluding Weekends

Calculating turnaround time can be an easy task for a small range of people. But when we want to do so for a large dataset, we need the help of spreadsheets that can make our task easy. We will talk about the ways those can be used for calculating turnaround time excluding weekends in Excel. This is an overview of the approaches that will be used and the respective outputs from each approach.

Summary of this article


๐Ÿ“ Download Excel File

Download the practice workbook below.


What is Turnaround Time?

Turnaround time is when a process or a request takes before fulfillment. It is the time interval from the time of submission to the time of completion. In computing terms, turnaround time refers to the time that a program takes starting from its execution to the delivery of output after the launch of the program. In logistics, turnaround time is the time from the submission of a fulfillment request to the time the order has been fulfilled. Turnaround time is important as the less this time is, the faster the companies can earn profit. For instance, the faster one can complete their role, the faster the product goes into the process of completion.


Learn to Calculate Turnaround Time Excluding Weekends in Excel with These 3 Approaches

Here, we will look at 3 different approaches by which we can determine turnaround time excluding weekends in Excel. To demonstrate things easily, we will consider a dataset where we have the employee names, start and end dates, and working hours per day. The dataset is shown as follows:

Sample dataset to calculate turnaround time in Excel

We will use these data to determine turnaround time with the following approaches.

Approach

1. Incorporating NETWORKDAYS Function

NETWORKDAYS function can be used as a simple approach for calculating turnaround time. The steps for this approach are as follows:

โฌ‡๏ธโฌ‡๏ธ STEPS โฌ‡๏ธโฌ‡๏ธ

  • First, we choose cell F6, then insert the formula below.

=NETWORKDAYS($C6,$D6)

๐Ÿ”จ Formula Breakdown

NETWORKDAYS($C6,$D6)

๐Ÿ‘‰ย  The first argument in cell $C6 denotes start date.

๐Ÿ‘‰ย  The second argument in cell $D6 denotes end date.

Formula based on NETWORKDAYS function

  • Next, we press Enter.
  • Then, we drag Fill Handle to cell F12.

Dragging Fill Handle

  • This will provide us with a turnaround time value in days for all employees.

Turnaround time results for NETWORKDAYS function

  • After that, we move to cell G6 and insert the following formula.
=F6*$E$6

Turnaround time in hour formula for NETWORKDAYS function

  • Turnaround time will convert into hours for cell G6. Now, we drag Fill Handle of cell G6 to cell G12.

Dragging Fill Handle

  • The final output results will look like the following image.

Calculating turnaround time using NETWORKDAYS function

๐Ÿ“• Read More: Calculate Hours Between Two Dates and Times in Excel Excluding Weekends

Approach

2. Inserting Excel NETWORKDAYS.INTL Function with Custom Weekend

In this approach, we will use NETWORKDAYS.INTL function to find out turnaround time value in days and then hours. This is an advanced form of NETWORKDAYS function, by which we can customize weekends in an argument. The steps for this approach are as follows:

โฌ‡๏ธโฌ‡๏ธ STEPS โฌ‡๏ธโฌ‡๏ธ

  • At first, we move to cell F6.
  • After that, insert the formula below.

=NETWORKDAYS.INTL($C6,$D6,7)

๐Ÿ”จ Formula Breakdown

NETWORKDAYS.INTL($C6,$D6,7)

๐Ÿ‘‰ย  The first argument in cell $C6 denotes the start date.

๐Ÿ‘‰ย  The second argument in cell $D6 denotes the end date.

๐Ÿ‘‰ย  7 indicates the weekend number where the weekends are on Friday as well as Saturday.

NETWORKDAYS.INTL function

  • After that, we press Enter.
  • Now, drag Fill Handle icon at the bottom right of cell F6 to cell F12.

Dragging Fill Handle

  • Thus, we will get turnaround times in days.

Turnaround time results in days

  • Then, we select cell G6 and insert the following formula.

=F6*$E$6

Turnaround time in hour formula for NETWORKDAYS.INTL function

  • Cell G6 will show the value in hours. Next, we drag Fill Handle at the bottom right of cell G6 to cell G12.

Dragging Fill Handle

  • The output results will look like the following image.

Turnaround time results using NETWORKDAYS.INTL function

๐Ÿ“• Read More: 7 Examples to Calculate Duration of Time in Excel

Approach

3. Combination of Multiple Functions for Turnaround Time

In this approach, we will make use of combined functions to create a formula in order to find out turnaround time. The functions include IF, NETWORKDAYS, MOD, and WEEKDAY functions. This method is a bit different than the other two. It is because, when we use NETWORKDAYS function, it calculates the days starting from the commencement of the 1st date to the ending of the second date. If both of such days are workdays, we need to subtract the commencement of the 1st day (From midnight to Begin Time) and last portion of the ending day (Ending time until Midnight). This combined function makes sure of that. The steps for this approach are as follows:

โฌ‡๏ธโฌ‡๏ธ STEPS โฌ‡๏ธโฌ‡๏ธ

  • In the beginning, we move to cell G6 and enter the following formula.

=NETWORKDAYS($C6,$D6)+IF(MOD(WEEKDAY($D6),7)>1, MOD($D6,1)-1,0)-IF(MOD(WEEKDAY($C6),7)>1,MOD($C6,1),0)

๐Ÿ”จ Formula Breakdown

NETWORKDAYS($C6,$D6)+IF(MOD(WEEKDAY($D6),7)>1,MOD($D6,1)-1,0)-IF(MOD(WEEKDAY($C6),7)>1,MOD($C6,1),0)

๐Ÿ‘‰ย  The portion NETWORKDAYS($C6,$D6) indicates the number of days except for weekdays between the start date in cell C6 and end date in cell D6.

๐Ÿ‘‰ย  WEEKDAY($D6) denotes the nth day of weekday date in cell D6 is. For weeks starting from Sunday, we can say we will obtain a value of 5 if date in cell D6 is a Thursday.

๐Ÿ‘‰ย  MOD(WEEKDAY($D6),7) function has the first argument as number and the second argument 7 as the divisor.

๐Ÿ‘‰ย  IF(MOD(WEEKDAY($D6),7)>1,MOD($D6,1)-1,0) portion of the formula suggests that, under the IF function, the first argument MOD(WEEKDAY($D6),7)>1,MOD($D6,1)-1 is the condition and the second argument 0 is the value to return if the condition is satisfied or true.

Combined function to calculate turnaround time.

  • After that, we press Enter.
  • Now, drag Fill Handle at the bottom right of cell F6 to cell G12.

Dragging Fill Handle

  • Turnaround time values in days will be visible now.

Turnaround time in days

  • Then, we move to cell G6 and insert the following formula.

=F6*$E$6

Turnaround time in hours formula

  • We drag Fill Handle again at the bottom right of cell G6 to cell G12.

Dragging Fill Handle

  • The results will look like the following image.

Turnaround time results in hours.

๐Ÿ“• Read More: 5 Ways to Calculate Total Hours Worked in a Week in Excel


๐Ÿ“„ย  Important Notes

๐Ÿ–Š๏ธย  NETWORKDAYS and NETWORKDAYS.INTL functions calculate time from the beginning of the 1st date to the ending of the second date.

๐Ÿ–Š๏ธย  NETWORKDAYS.INTL allows us to choose the weekends, unlike NETWORKDAYS function.


๐Ÿ“ย  Takeaways from This Article

You have taken the following summed-up inputs from the article:

๐Ÿ“Œ ย We can use NETWORKDAYS function to forecast turnaround time. This is the simplest way.

๐Ÿ“Œย  We can also specify weekends and therefore to do that, we have to use NETWORKDAYS.INTL to measure turnaround time.

๐Ÿ“Œย  Lastly using combined functions, we can get rid of the extra time accounted in the previous two approaches.


Conclusion

To conclude, I hope that this article has helped you to understand how to calculate turnaround time excluding weekends in Excel. For any kind of query, reach out to us by leaving a comment below. Follow our website ExcelDen for more informative articles related to Excel.


Related Articles

(Visited 64 times, 1 visits today)
Abrar

Abrar

Hello there! I am Mohammad Abrar Uddin, an engineering graduate from BUET. I write articles and blogs related to Excel in this site and hope that the viewers can learn simple to complex solutions of Excel problems easily by reading such articles.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo