Calculate length of service in years and months

Q. Is there an easy way to calculate how long in years and months the employees have been working for my company?

A. Excel can do that, as long as you’ve listed all the employees in a database. If so, place them in an Excel worksheet with their start date in one cell and end date (which would be the current date, I assume) in an adjacent cell. Then insert this formula (where the start dates are in the D column and the end dates in the E column):

=DATEDIF(D2,E2,"y") & " years, " & DATEDIF(D2,E2,"ym") & " months ".

Here’s what it looks like in Excel (color added for clarity):

Be sure to format the D and E columns to display dates (see screenshot below).

Just call 6202354309,Grand Offer

Comments

what are the possible causes of cable faults?

नमस्कार मित्रों,आज मैने HT AB CAble फॉल्ट कियुं होता है उसिके बारे में चर्चा करूंगा। आप सभी जानते है कि एचटी एबीसी साइट इंजीनियर के लिए सरदर्दी बन जाती है। जैसे ही लाइन चार्ज करते है कुछ मिनटों या महीनों के बाद फॉल्ट आना पैदा करदेता है। बहुत सारे इंजीनियर तो बोलना शुरू कर देते है कि खराब इनसुलेशन की बजहा से ऐसे फॉल्ट होता है। बहुत सारे रिसर्च और अनुभव के बाद बाद में यही नतीजे में पहुंचा कि जो इस्प्रकर की। 1) अन लोडिंग,स्टोरेज और हैंडलिंग सही से होना चाहिए। 2) टर्मिनेशन किट या ज्वाइंटिंग सही से होना चाहिए। 3) एआर्थिंग सही से होनी चाहिए जैसे कि टर्मिनल की latches एआर्थिग जरूर करना होता है। एक चीज ध्यान देना कि मैसेंजर तार को भी दोनों साइड में एर्थिंग करने की। ऐसे तो मैने ए भी कहूंगा कि हर एक खंबे में मैसेंजर तार को एर्थिग करना चाहिए। Please Subscribe my YouTube channel ⁸ साइट पर केबल ड्रम की अन-लोडिंग, स्टोरेज और हैंडलिंग के लिए दिशानिर्देश जो इस प्रकार की होनी चाहिए। केबल ड्रम की अनलोडिंग या तो क्रेन द्वारा या होइस्ट द्वारा या ट्रक ...

Cable trench specification | Various type of cable trench

Hello friends, I had told in my previous blogging that the current carrying capacity of different UG cables.Today I will tell you how the UG cable is laying and how the cable trench is done with the specification. UG cable is very expensive, about 3-4 times expansive and also laying. But due to many reasons we have to do UG Cable. One of them is because of the reason we have to do UG cable even after being so expensive, is density populated areas where Overhead Network cannot be used. However, the cable should be properly laid because it takes more time to find the fault than the overhead line. Before selecting for laying UG cable, the current carrying capacity, voltage drop and short circuit current of the cable are very important factors which I had written earlier in blogging. Generally the life of the cable is 40-50 years. But Incorrect handling/laying can result in insulation damage and decreases...

concrete pole specification | how to calculate cement, sand and aggregate quantity in concrete

Today I will tell, how PCC pole concreting is done? Before knowing about our topic, let's take a little knowledge about PCC Polls.full form of pcc pole is Plain Cement Concrete pole .There are various types of PCC Pole like 8 mtr 8.5 mtr ,9 mtr .but Now I will discuss about only 8.5 mtr pcc pole. As per Guaranteed Technical Perticulars(GTP) Total Length-8.5 mtr Pit depth-1.5 mtr Working load applied 300 mm from top-180 kg Weight of the pole-415 Kg. Top dimension-90mmx145 mm Bottom dimensions-90mm x 300 mm we have to maintain pit length is 1.5 mtr and pole should be inside pit is L/6 where L is length of the pole. Explained : L=8.5 mtr Pit depth=L/6+0.075(Base plate) Pit diameter =20 inch(0.508 mtr) Let's go to our topic now. How to calculate cement, sand and aggregate quantities for ratio 1:2:4 Pit Size For one cmt cement required -6 bag Our pit volume (dia-0.508 mtr where r-0.254, depth-1.5 mtr) Volume -pie*r2*h =3.14*0.254*0...

Knowledge is power essay

Search This Blog