Spreadsheet: 548219d1510935898-how-to-format-for-years-months-days-spelled-out-employees
Sheet: Sheet1

Last Name | First Name | ID | Rate | Dept | Hire Date | Duration
Acosta | Andres | 10538 | 10.5 | 600 | 2017-01-12 00:00:00
Arvizo | Victor | 108 | 16 | 300 | 2012-08-07 00:00:00 | 5 Yrs 3 Mos 10 Days
[NAME] | [NAME] | 5664 | 13 | 700 | 2017-08-16 00:00:00 | 3 Mos 1 Day
[NAME] | [NAME] | 10517 | 11.5 | 400 | 2017-06-12 00:00:00 | 5 Mos 5 Days
[NAME] | [NAME] | 10063 | 12 | 300 | 2016-06-14 00:00:00 | 1 Yr 5 Mos 3 Days
Callaway | [NAME] | 10010 | 17.5 | 700 | 2008-05-01 00:00:00 | 9 Yrs 6 Mos 16 Days
Calona | [NAME] | 10598 | 10.5 | 300 | 2017-06-16 00:00:00 | 5 Mos 1 Day
[NAME] | Calvin | 10013 | 12 | 300 | 2012-01-12 00:00:00 | 5 Yrs 10 Mos 5 Days
[NAME] | Lauro | 194 | 13.5 | 300 | 2013-06-29 00:00:00 | 4 Yrs 4 Mos 19 Days
Chacon Fernandez | Yarleni | 10066 | 11 | 300 | 2017-01-03 00:00:00 | 10 Mos 14 Days
[NAME] | Yesenia | 10514 | 10.5 | 200 | 2016-12-21 00:00:00 | 10 Mos 27 Days
Cooke | [NAME] | 228 | 15 | 700 | 2017-06-16 00:00:00 | 5 Mos 1 Day
Crow | Maria | 10017 | 20 | 300 | 2009-05-20 00:00:00 | 8 Yrs 5 Mos 28 Days
D'Anza | [NAME] | 10274 | 11 | 300 | 2016-12-06 00:00:00 | 11 Mos 11 Days
Daugherty | Douglason | 7750 | 9.5 | 300 | 2017-09-01 00:00:00 | 2 Mos 16 Days
[NAME] | Nidia | 10072 | 13 | 300 | 2016-05-24 00:00:00 | 1 Yr 5 Mos 24 Days
[NAME] | Aida | 0895 | 9.5 | 300 | 2017-08-23 00:00:00 | 2 Mos 25 Days
Dimmick | Orrin | 10476 | 16.5 | 700 | 2016-08-11 00:00:00 | 1 Yr 3 Mos 6 Days
Dominguez | Alexis | 10576 | 9.5 | 600 | 2017-06-01 00:00:00 | 5 Mos 16 Days
Duarte | Miguel | 10479 | 12.25 | 600 | 2017-07-08 00:00:00 | 4 Mos 9 Days
Dunham | [NAME] | 10453 | 16 | 500 | 2016-06-30 00:00:00 | 1 Yr 4 Mos 18 Days
Fay | [NAME] | 10601 | 12 | 500 | 2017-06-20 00:00:00 | 4 Mos 28 Days
Fultz | [NAME] | 109 | 21.75 | 100 | 2012-08-15 00:00:00 | 5 Yrs 3 Mos 2 Days
Gallegos | [NAME] | 10483 | 9.5 | 500 | 2016-04-04 00:00:00 | 1 Yr 7 Mos 13 Days
[NAME] | Clay | 6655 | 10.5 | 400 | 2017-09-29 00:00:00 | 1 Mon 19 Days
[NAME] | Kathy | 10592 | 9.5 | 200 | 2017-06-13 00:00:00 | 5 Mos 4 Days
[NAME] | Victor | 152 | 13 | 600 | 2013-08-30 00:00:00 | 4 Yrs 2 Mos 18 Days
[NAME] | Shelby | 10033 | 17 | 700 | 2011-08-22 00:00:00 | 6 Yrs 2 Mos 26 Days
Hays | [NAME] | 5188 | 9.5 | 600 | 2017-09-14 00:00:00 | 2 Mos 3 Days
Heathcote | Nichole | 10251 | 13 | 500 | 2015-07-17 00:00:00 | 2 Yrs 4 Mos
Henderson | Trevor | 10624 | 10.5 | 300 | 2017-07-11 00:00:00 | 4 Mos 6 Days
Hernandez | [NAME] | 172 | 25 | 700 | 2013-05-21 00:00:00 | 4 Yrs 5 Mos 27 Days
Hernandez | [NAME] | 10345 | 13 | 200 | 2015-10-09 00:00:00 | 2 Yrs 1 Mon 8 Days
Hernandez | Amanda | 2347 | 14 | 200 | 2017-09-08 00:00:00 | 2 Mos 9 Days
Hester | [NAME] | 10575 | 13 | 700 | 2017-05-23 00:00:00 | 5 Mos 25 Days
Hoffarth | [NAME] | 10035 | 0 | 500 | 2010-12-30 00:00:00 | 6 Yrs 10 Mos 18 Days
Hollandsworth | Ryah | 10597 | 9.5 | 300 | 2017-06-12 00:00:00 | 5 Mos 5 Days
Hurtado | Claudia | 10614 | 11 | 200 | 2017-06-27 00:00:00 | 4 Mos 21 Days
[NAME] | [NAME] | 10564 | 15 | 700 | 2017-03-07 00:00:00 | 8 Mos 10 Days
[NAME] | [NAME] | 10041 | 9.5 | 300 | 2017-01-04 00:00:00 | 10 Mos 13 Days
[NAME] | [NAME] | 10626 | 9.5 | 300 | 2017-07-17 00:00:00 | [NAME]
Martinez Flores | [NAME] | 93 | 16 | 300 | 2012-07-10 00:00:00 | 5 Yrs 4 Mos 7 Days
[NAME] | Camron | 10602 | 9.5 | 300 | 2017-06-21 00:00:00 | 4 Mos 27 Days
[NAME] | [NAME] | 10587 | 9.5 | 300 | 2017-06-13 00:00:00 | 5 Mos 4 Days
Miranda | Lester | 10369 | 14 | 700 | 2015-12-28 00:00:00 | 1 Yr 10 Mos 20 Days
Montoya | [NAME] | 390 | 11.5 | 300 | 2017-03-02 00:00:00 | 8 Mos 15 Days
Moreno | Amador | 316 | 14 | 100 | 2016-10-13 00:00:00 | 1 Yr 1 Mon 4 Days
[NAME] | Juanita | 101 | 11 | 300 | 2012-07-16 00:00:00 | 5 Yrs 4 Mos 1 Day
Olsen-Allred | Zachery | 10607 | 9.5 | 400 | 2017-06-23 00:00:00 | 4 Mos 25 Days
Ortego | [NAME] | 10579 | 13 | 700 | 2017-06-02 00:00:00 | 5 Mos 15 Days
Ortiz | Teresa | 10516 | 10.75 | 300 | 2016-12-26 00:00:00 | 10 Mos 22 Days
[NAME] | [NAME] | 10604 | 9.5 | 300 | 2017-06-22 00:00:00 | 4 Mos 26 Days
Portillo | Briseyda | 10523 | 11.5 | 300 | 2016-12-29 00:00:00 | 10 Mos 19 Days
Portillo-Olivas | Cesar | 88 | 12 | 300 | 2012-07-05 00:00:00 | 5 Yrs 4 Mos 12 Days
[NAME] | [NAME] | 130 | 16.25 | 700 | 2012-12-31 00:00:00 | 4 Yrs 10 Mos 17 Days
[NAME] | Jackeline | 7066 | 9.5 | 300 | 2017-08-30 00:00:00 | 2 Mos 18 Days
Reiner | Shawn | 10138 | 13 | 300 | 2017-05-22 00:00:00 | 5 Mos 26 Days
Richert | Terrell | 10376 | 14 | 500 | 2016-01-01 00:00:00 | 1 Yr 10 Mos 16 Days
Rodriguez | Gladys | 10283 | 12 | 300 | 2015-12-19 00:00:00 | 1 Yr 10 Mos 29 Days
Rodriguez | Jorge | 10623 | 9.5 | 400 | 2017-07-07 00:00:00 | 4 Mos 10 Days
Rojas | [NAME] | 10561 | 9.5 | 300 | 2017-05-26 00:00:00 | 5 Mos 22 Days
Roling | April | 10137 | 13 | 200 | 2015-03-19 00:00:00 | 2 Yrs 7 Mos 29 Days
Ruiz | Nathan | 2695 | 14 | 700 | 2017-11-06 00:00:00 | 11 Days
Salas | Sandra | 148 | 12 | 300 | 2013-01-09 00:00:00 | 4 Yrs 10 Mos 8 Days
Segura | [NAME] | 10353 | 12 | 200 | 2015-12-17 00:00:00 | 1 Yr 11 Mos
Shumway | Elmina | 2938 | 9.5 | 300 | 2017-07-21 00:00:00 | 3 Mos 27 Days
Sorrell | [NAME] | 10588 | 9.5 | 300 | 2017-06-13 00:00:00 | 5 Mos 4 Days
[NAME] | [NAME] | 393 | 17.5 | 100 | 2014-10-27 00:00:00 | 3 Yrs 21 Days
Thorpe | [NAME] | 10437 | 12 | 200 | 2016-06-08 00:00:00 | 1 Yr 5 Mos 9 Days
Turcios M | [NAME] | 10582 | 9.5 | 300 | 2017-06-07 00:00:00 | 5 Mos 10 Days
Urquhart | [NAME] | 10593 | 11 | 400 | 2017-06-13 00:00:00 | 5 Mos 4 Days
Valdez | [NAME] | 1538 | 9.5 | 300 | 2017-08-17 00:00:00 | 3 Mos
Vargas | Leandro | 10124 | 13.5 | 400 | 2015-03-05 00:00:00 | 2 Yrs 8 Mos 12 Days
Velasco | Veronica | 72 | 11.5 | 300 | 2012-01-12 00:00:00 | 5 Yrs 10 Mos 5 Days
Vera | Bertha | 297 | 15 | 100 | 2014-12-28 00:00:00 | 2 Yrs 10 Mos 20 Days
Vera | Bertha | 112 | 14 | 200 | 2012-11-19 00:00:00 | 4 Yrs 11 Mos 29 Days
Vera | Isamari | 303 | 13 | 200 | 2014-12-27 00:00:00 | 2 Yrs 10 Mos 21 Days
Vera-Vargas | Maria | 73 | 13 | 300 | 2007-07-25 00:00:00 | 10 Yrs 3 Mos 23 Days
Walters | [NAME] | 10086 | 16 | 600 | 2017-06-27 00:00:00 | 4 Mos 21 Days
[NAME] | Louis | 10319 | 11.4 | 600 | 2016-06-30 00:00:00 | 1 Yr 4 Mos 18 Days