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:
drive.google.com/file/d/1UPR9...
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.
For Personalized detail learning, write to [e-mail]
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.
***********************************************
★ My Online Tutorials ► www.dptutorials.com
LEARNING RESOURCES I Recommend: www.dptutorials.com/resources
Subscribe for more Awesome Tutorials: goo.gl/NyAtg2
Support the Channel via shopping: ift.tt/2jH38PR
Tools for youtube vlogging:
• Laptop: amzn.to/2CaLFxJ fkrt.it/AM9ab_uuuN
• Canon 200D Camera: amzn.to/3d7jDR4 fkrt.it/AMz75_uuuN
• Benro Tripod: amzn.to/3exQoax fkrt.it/An1lm_uuuN
• Microphone: amzn.to/3c5lEvS fkrt.it/A2RHz_uuuN
• Collar Microphone: amzn.to/2X8DWrS fkrt.it/yL8kdQNNNN
• Screen recorder: techsmith.pxf.io/2BMjA
• Boom Arm Stand: amzn.to/3extb87 fkrt.it/ypUD8QNNNN
• Zoom H1 Audio Recorder: amzn.to/2TNdHFj fkrt.it/ypb7WQNNNN
• Harison Softbox Studio Lights: amzn.to/3caGbzg fkrt.it/ypCaRQNNNN
• Chroma Key Green Screen: amzn.to/2M60mn4 fkrt.it/A3gnb_uuuN
• Background Support Stand: amzn.to/3dbACSv fkrt.it/A3cCb_uuuN
• Acoustic Foam Background: amzn.to/3gzFtyC fkrt.it/ypsGdQNNNN
• USB RGB LED Strip: amzn.to/36BpCLF fkrt.it/A3T_5_uuuN
• Wireless Mouse: amzn.to/2TPIrW7 fkrt.it/A3Bqz_uuuN
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:
RUclips: / dptutorials
G+: ift.tt/2kAOpa6
Twitter: / dptutorials15
Facebook: ift.tt/2kfRnDi
BlogSpot: ift.tt/2kB14dh
Follow:
www.dptutorials.com
www.askplanner.blogspot.com
#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-po9df]

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

[@shri_420]

Thank you so much .. I am sure many like me were searching for this for a long time.

[@TheMaddy6666]

very helpful thank you so much

[@ammujoseph8783]

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

[@coolblue1524]

Brilliant!!

[@midhunramachandran5131]

Awesome n thanks bro... ❤❤❤

[@vishaljaiswal4721]

I need to give this one a try.

[@user-xp6hg2ld6z]

Thank you!

[@uLeabric]

Thank you! This solves my puzzle perfectly.

[@denisestanczyk5755]

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!

[@anupamchoudhary6168]

This is very informative and nicely explained. Thank you!

[@harishkharishkrishna2762]

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

[@jayantadas8259]

Excellent

[@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.

[@silvestrecamposano6317]

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

[@saketmaurya]

thanku man.

[@hariommishra8075]

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

[@nazerbor3i]

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

[@ranjitjojo]

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

[@theruler9999]

Hi, thank for the valuable info, In the given example, you mentioned that it's for the case if I have two dates with two time stamps, what should be changed if I have only one date and one time stamp?