How To Calculate SLA or TAT by excluding non business hours || Excel Tricks

In this tutorial, let us learn How To Calculate SLA or TAT by excluding non-business hours

Download the Excel file here:

Here, I will be showing with two examples one where I have the date and time fields in 2 different columns and other case I have the date and time in the same column.

Here, I have the reporting date and time; Response date and time. And Let us calculate the SLAs or Turnaround times.

Generally, what everyone does is a normal subtraction, with which we can’t exclude the non-business hours and hence, it will be reflecting the wrong results.

But, watch this tutorial to learn through advanced formula.

If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later.

***********************************************

Tools for youtube vlogging:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

***********************************************

You Can Connect with Me at:

Follow:

#dptutorials #Exceltraining #ExcelTricks #ExcelTips #ExcelFreeTraining #ExcelFreeLearning

Tags: -
excel formulas in English, excel in English, excel tutorial in English,ms excel in English,ms excel tutorial in English, learn excel in English,vlookup in excel in English, learn ms excel in English, excel training, excel tutorial, Microsoft Excel 2007, learn excel,tutorial excel, ms excel tutorial, excel tutorials,ms excel 2007,Microsoft Excel training,learn excel online,learning excel,free excel training,online excel training,advanced excel tutorial,excel tutorial, excel formulas and functions, excel formulas, excel tutorial in Hindi, excel formulas and functions in Hindi, excel tricks, excel in Hindi, excel shortcut keys, excel vlookup, excel formulas in Hindi, excel for beginners, excel for accounting, excel formulas and functions tutorial, Excel Sum Formula, Sum Formula series, excel attendance sheet, excel salary sheet, excel stock maintain, excel data entry, advanced excel tutorial,excel formulas,excel tutorial,vlookup excel,excel accounting,excel for beginners,excel shortcut keys,excel sum formula,excel training,excel training online,excel tricks,free excel training,learn excel,learn excel online,microsoft excel training,attendance sheet in excel,excel data entry,excel formulas and functions,microsoft excel 2007, ms excel tutorial, excel formulas, and functions in hindi

[MuhammadAmin-podf]

Thanks alot, it is very helpful. I had very difficulty in calculating the TAT. Now got understand. Thanks.

[shri_]

Thank you so much .. I am sure many like me were searching for this for a long time.
Also there are other pages and videos about this but you explained in a better way.

[manuelc]

Thanks a lot, i was looking for this exact formulas.

[hariommishra]

Bhai i want to salute you know you give me a relief..from this pain

[mukeshvishal]

Thanks a lot. I was looking for this type of formula. Very neatly explained

[harishkharishkrishna]

Thank you so much sir.. it's really helpful to whoever is looking for tat calculations as accurate as U r a great teacher ...

[ammujoseph]

I finally understand what Median and MOD used for And lost days looking for this kind of a solution. Hats off to U👍

[silvestrecamposano]

Thank you very much Sir!... I have been looking for this formula...

[denisestanczyk]

thank you VERY MUCH! I was looking for this for days and couldn't find a tutorial good as yours! it's exactly what I need!

[nazerbori]

you deserve a likes for this video, you earned the subscribe and like

[anupamchoudhary]

This is very informative and nicely explained. Thank you!

[uLeabric]

Thank you! This solves my puzzle perfectly.

[hemantsawant]

Hey thanks for the solution but time is wrongly calculated when the days difference is more than 2 days. It’s not calculating more than 24 hrs.

[sravankadaveru]

This is very good information, and useful. But, can you also help with some more info for how to consider public holidays to it. Please.

[Sharks-mc]

This has been the formula I have been looking for for AGES, so thank you! I do have another problem... if someone works something on a Sunday (the only day we are closed) how can this still be counted? So my example is the item arrived at 5pm on Saturday, (our working hours are 8am to 6pm mon to sat) but it was then actioned on the Sunday, but I want to still count this as taking 1 hour (5pm sat to 6pm sat) can this be included?
And how can I add in bank holidays to count as non working days?
THANK YOU

[Riyas]

I appreciated, which is I'm an expected the same formula I got it. Let me workout if anything let you know.

[joemillovich]

This works perfect for business days, but what if i only want to exclude non-business hours (i.e. 7 days a week excluding 5pm-8am)?

[ranjitjojo]

Sir, I have a question- if it's a 24/7 queue, how to tweek the formula

[sainathsarath]

@dptutorials Thanks for the content, can you please help me with the same to add holidays list in the formula. Thanks in advance!

[swamyh]

Am working Sunday's also but this formula not accepting on Sundays duration kindly suggest