Hey, I need help sorting out student attendance data.
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; -webkit-text-stroke: #000000}span.s1 {font-kerning: none}</style>
For example, this is January Sheet.
Data is sorted by Column B (#ID)
<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl63 {border:.5pt solid windowtext;}.xl64 {border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:none;}.xl65 {border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext;}.xl66 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:left; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl67 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border-top:.5pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl68 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border-top:none; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl69 {font-weight:700;}.xl70 {mso-number-format:"\[h\]\:mm"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}.xl71 {mso-number-format:"\[h\]\:mm"; border:.5pt solid windowtext; background:white; mso-pattern:black none;}.xl72 {mso-number-format:"\[h\]\:mm"; border-top:none; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}.xl73 {mso-number-format:"\[h\]\:mm"; border-top:.5pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}.xl74 {font-weight:700; text-align:center; vertical-align:middle; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl75 {color:windowtext; font-weight:700; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl76 {font-weight:700; mso-number-format:"\[h\]\:mm"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}.xl77 {font-weight:700; text-align:left; vertical-align:middle; border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl78 {font-weight:700; mso-number-format:"dddd\\ mm\/dd\/yy"; text-align:center; border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl79 {font-weight:700; mso-number-format:"dddd\\ mm\/dd\/yy"; text-align:center; border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:none; background:white; mso-pattern:black none;}.xl80 {font-weight:700; mso-number-format:"dddd\\ mm\/dd\/yy"; text-align:center; border-top:1.0pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:1.0pt solid windowtext; border-left:none; background:white; mso-pattern:black none;}.xl81 {mso-number-format:"Medium Time"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none; background:white; mso-pattern:black none;}.xl82 {mso-number-format:"Medium Time"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}--></style>[TABLE="width: 780"]
<tbody>[TR]
[TD="class: xl77, width: 65"]Name[/TD]
[TD="class: xl74, width: 65"]#ID[/TD]
[TD="class: xl78, width: 195, colspan: 3"]Monday 01/01/18[/TD]
[TD="class: xl78, width: 195, colspan: 3"]Tuesday 01/02/18[/TD]
[TD="class: xl79, width: 195, colspan: 3"]Wednesday 01/03/18[/TD]
[TD="class: xl75, width: 65"]TOTAL[/TD]
[/TR]
[TR]
[TD="class: xl66"]Caroline[/TD]
[TD="class: xl68"]01A[/TD]
[TD="class: xl81, align: right"]9:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl72, align: right"]7:00[/TD]
[TD="class: xl81, align: right"]9:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl72, align: right"]7:00[/TD]
[TD="class: xl81, align: right"]9:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl70, align: right"]7:00[/TD]
[TD="class: xl76, align: right"]21:00[/TD]
[/TR]
[TR]
[TD="class: xl66"]Ben[/TD]
[TD="class: xl67"]02A[/TD]
[TD="class: xl81, align: right"]10:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl73, align: right"]6:00[/TD]
[TD="class: xl81, align: right"]10:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl73, align: right"]6:00[/TD]
[TD="class: xl81, align: right"]10:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl71, align: right"]6:00[/TD]
[TD="class: xl76, align: right"]18:00[/TD]
[/TR]
[TR]
[TD="class: xl66"]Denize[/TD]
[TD="class: xl67"]03A[/TD]
[TD="class: xl81, align: right"]11:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl73, align: right"]5:00[/TD]
[TD="class: xl81, align: right"]11:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl73, align: right"]5:00[/TD]
[TD="class: xl81, align: right"]11:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl71, align: right"]5:00[/TD]
[TD="class: xl76, align: right"]15:00[/TD]
[/TR]
[TR]
[TD="class: xl66"]Alex[/TD]
[TD="class: xl68"]04A[/TD]
[TD="class: xl81, align: right"]9:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl72, align: right"]7:00[/TD]
[TD="class: xl81, align: right"]9:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl72, align: right"]7:00[/TD]
[TD="class: xl81, align: right"]9:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl70, align: right"]7:00[/TD]
[TD="class: xl76, align: right"]21:00[/TD]
[/TR]
</tbody>[/TABLE]
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; -webkit-text-stroke: #000000}span.s1 {font-kerning: none}</style>I have another sheet which sums up all hours for each student. Also sorted by Column B (#ID)
<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl63 {border:.5pt solid windowtext;}.xl64 {border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:none;}.xl65 {border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext;}.xl66 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:left; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl67 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border-top:.5pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl68 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border-top:none; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl69 {font-weight:700;}.xl70 {font-weight:700; text-align:left; vertical-align:middle; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl71 {font-weight:700; text-align:center; vertical-align:middle; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl72 {font-weight:700; mso-number-format:"dddd\\ mm\/dd\/yy"; text-align:center; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl73 {color:windowtext; font-weight:700; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl74 {mso-number-format:"h\:mm\;\@"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none; background:white; mso-pattern:black none;}.xl75 {mso-number-format:"Short Time"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none; background:white; mso-pattern:black none;}.xl76 {font-weight:700; mso-number-format:"\[h\]\:mm"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}--></style>[TABLE="width: 715"]
<tbody>[TR]
[TD="class: xl70, width: 65"]Name[/TD]
[TD="class: xl71, width: 65"]#ID[/TD]
[TD="class: xl72, width: 65"]January[/TD]
[TD="class: xl72, width: 65"]February[/TD]
[TD="class: xl72, width: 65"]March[/TD]
[TD="class: xl72, width: 65"]April[/TD]
[TD="class: xl72, width: 65"]September[/TD]
[TD="class: xl72, width: 65"]October[/TD]
[TD="class: xl72, width: 65"]November[/TD]
[TD="class: xl72, width: 65"]December[/TD]
[TD="class: xl73, width: 65"]TOTAL[/TD]
[/TR]
[TR]
[TD="class: xl66"]Caroline[/TD]
[TD="class: xl68"]01A[/TD]
[TD="class: xl74, align: right"] 21:00[/TD]
[TD="class: xl75, align: right"]22:00[/TD]
[TD="class: xl75, align: right"]15:00[/TD]
[TD="class: xl75, align: right"]22:00[/TD]
[TD="class: xl75, align: right"]17:00[/TD]
[TD="class: xl75, align: right"]15:00[/TD]
[TD="class: xl75, align: right"]22:00[/TD]
[TD="class: xl75, align: right"]15:00[/TD]
[TD="class: xl76, align: right"]149:00[/TD]
[/TR]
[TR]
[TD="class: xl66"]Ben[/TD]
[TD="class: xl67"]02A[/TD]
[TD="class: xl74, align: right"]18:00[/TD]
[TD="class: xl75, align: right"]23:00[/TD]
[TD="class: xl75, align: right"]17:00[/TD]
[TD="class: xl75, align: right"]23:00[/TD]
[TD="class: xl75, align: right"]22:00[/TD]
[TD="class: xl75, align: right"]17:00[/TD]
[TD="class: xl75, align: right"]23:00[/TD]
[TD="class: xl75, align: right"]17:00[/TD]
[TD="class: xl76, align: right"]160:00[/TD]
[/TR]
[TR]
[TD="class: xl66"]Denize[/TD]
[TD="class: xl67"]03A[/TD]
[TD="class: xl74, align: right"]15:00[/TD]
[TD="class: xl75, align: right"]20:00[/TD]
[TD="class: xl75, align: right"]19:00[/TD]
[TD="class: xl75, align: right"]20:00[/TD]
[TD="class: xl75, align: right"]8:00[/TD]
[TD="class: xl75, align: right"]19:00[/TD]
[TD="class: xl75, align: right"]20:00[/TD]
[TD="class: xl75, align: right"]19:00[/TD]
[TD="class: xl76, align: right"]140:00[/TD]
[/TR]
[TR]
[TD="class: xl66"]Alex[/TD]
[TD="class: xl68"]04A[/TD]
[TD="class: xl74, align: right"]21:00[/TD]
[TD="class: xl75, align: right"]22:00[/TD]
[TD="class: xl75, align: right"]15:00[/TD]
[TD="class: xl75, align: right"]22:00[/TD]
[TD="class: xl75, align: right"]19:00[/TD]
[TD="class: xl75, align: right"]15:00[/TD]
[TD="class: xl75, align: right"]22:00[/TD]
[TD="class: xl75, align: right"]15:00[/TD]
[TD="class: xl76, align: right"]151:00[/TD]
[/TR]
</tbody>[/TABLE]
How can I sort data alphabetically by student names so that monthly and total hours don't get messed up?
Thanks!
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; -webkit-text-stroke: #000000}span.s1 {font-kerning: none}</style>
For example, this is January Sheet.
Data is sorted by Column B (#ID)
<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl63 {border:.5pt solid windowtext;}.xl64 {border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:none;}.xl65 {border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext;}.xl66 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:left; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl67 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border-top:.5pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl68 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border-top:none; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl69 {font-weight:700;}.xl70 {mso-number-format:"\[h\]\:mm"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}.xl71 {mso-number-format:"\[h\]\:mm"; border:.5pt solid windowtext; background:white; mso-pattern:black none;}.xl72 {mso-number-format:"\[h\]\:mm"; border-top:none; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}.xl73 {mso-number-format:"\[h\]\:mm"; border-top:.5pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}.xl74 {font-weight:700; text-align:center; vertical-align:middle; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl75 {color:windowtext; font-weight:700; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl76 {font-weight:700; mso-number-format:"\[h\]\:mm"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}.xl77 {font-weight:700; text-align:left; vertical-align:middle; border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl78 {font-weight:700; mso-number-format:"dddd\\ mm\/dd\/yy"; text-align:center; border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl79 {font-weight:700; mso-number-format:"dddd\\ mm\/dd\/yy"; text-align:center; border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:none; background:white; mso-pattern:black none;}.xl80 {font-weight:700; mso-number-format:"dddd\\ mm\/dd\/yy"; text-align:center; border-top:1.0pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:1.0pt solid windowtext; border-left:none; background:white; mso-pattern:black none;}.xl81 {mso-number-format:"Medium Time"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none; background:white; mso-pattern:black none;}.xl82 {mso-number-format:"Medium Time"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}--></style>[TABLE="width: 780"]
<tbody>[TR]
[TD="class: xl77, width: 65"]Name[/TD]
[TD="class: xl74, width: 65"]#ID[/TD]
[TD="class: xl78, width: 195, colspan: 3"]Monday 01/01/18[/TD]
[TD="class: xl78, width: 195, colspan: 3"]Tuesday 01/02/18[/TD]
[TD="class: xl79, width: 195, colspan: 3"]Wednesday 01/03/18[/TD]
[TD="class: xl75, width: 65"]TOTAL[/TD]
[/TR]
[TR]
[TD="class: xl66"]Caroline[/TD]
[TD="class: xl68"]01A[/TD]
[TD="class: xl81, align: right"]9:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl72, align: right"]7:00[/TD]
[TD="class: xl81, align: right"]9:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl72, align: right"]7:00[/TD]
[TD="class: xl81, align: right"]9:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl70, align: right"]7:00[/TD]
[TD="class: xl76, align: right"]21:00[/TD]
[/TR]
[TR]
[TD="class: xl66"]Ben[/TD]
[TD="class: xl67"]02A[/TD]
[TD="class: xl81, align: right"]10:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl73, align: right"]6:00[/TD]
[TD="class: xl81, align: right"]10:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl73, align: right"]6:00[/TD]
[TD="class: xl81, align: right"]10:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl71, align: right"]6:00[/TD]
[TD="class: xl76, align: right"]18:00[/TD]
[/TR]
[TR]
[TD="class: xl66"]Denize[/TD]
[TD="class: xl67"]03A[/TD]
[TD="class: xl81, align: right"]11:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl73, align: right"]5:00[/TD]
[TD="class: xl81, align: right"]11:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl73, align: right"]5:00[/TD]
[TD="class: xl81, align: right"]11:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl71, align: right"]5:00[/TD]
[TD="class: xl76, align: right"]15:00[/TD]
[/TR]
[TR]
[TD="class: xl66"]Alex[/TD]
[TD="class: xl68"]04A[/TD]
[TD="class: xl81, align: right"]9:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl72, align: right"]7:00[/TD]
[TD="class: xl81, align: right"]9:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl72, align: right"]7:00[/TD]
[TD="class: xl81, align: right"]9:00 AM[/TD]
[TD="class: xl82, align: right"]4:00 PM[/TD]
[TD="class: xl70, align: right"]7:00[/TD]
[TD="class: xl76, align: right"]21:00[/TD]
[/TR]
</tbody>[/TABLE]
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; -webkit-text-stroke: #000000}span.s1 {font-kerning: none}</style>I have another sheet which sums up all hours for each student. Also sorted by Column B (#ID)
<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl63 {border:.5pt solid windowtext;}.xl64 {border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:none;}.xl65 {border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext;}.xl66 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:left; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl67 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border-top:.5pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl68 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border-top:none; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl69 {font-weight:700;}.xl70 {font-weight:700; text-align:left; vertical-align:middle; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl71 {font-weight:700; text-align:center; vertical-align:middle; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl72 {font-weight:700; mso-number-format:"dddd\\ mm\/dd\/yy"; text-align:center; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl73 {color:windowtext; font-weight:700; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl74 {mso-number-format:"h\:mm\;\@"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none; background:white; mso-pattern:black none;}.xl75 {mso-number-format:"Short Time"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none; background:white; mso-pattern:black none;}.xl76 {font-weight:700; mso-number-format:"\[h\]\:mm"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}--></style>[TABLE="width: 715"]
<tbody>[TR]
[TD="class: xl70, width: 65"]Name[/TD]
[TD="class: xl71, width: 65"]#ID[/TD]
[TD="class: xl72, width: 65"]January[/TD]
[TD="class: xl72, width: 65"]February[/TD]
[TD="class: xl72, width: 65"]March[/TD]
[TD="class: xl72, width: 65"]April[/TD]
[TD="class: xl72, width: 65"]September[/TD]
[TD="class: xl72, width: 65"]October[/TD]
[TD="class: xl72, width: 65"]November[/TD]
[TD="class: xl72, width: 65"]December[/TD]
[TD="class: xl73, width: 65"]TOTAL[/TD]
[/TR]
[TR]
[TD="class: xl66"]Caroline[/TD]
[TD="class: xl68"]01A[/TD]
[TD="class: xl74, align: right"] 21:00[/TD]
[TD="class: xl75, align: right"]22:00[/TD]
[TD="class: xl75, align: right"]15:00[/TD]
[TD="class: xl75, align: right"]22:00[/TD]
[TD="class: xl75, align: right"]17:00[/TD]
[TD="class: xl75, align: right"]15:00[/TD]
[TD="class: xl75, align: right"]22:00[/TD]
[TD="class: xl75, align: right"]15:00[/TD]
[TD="class: xl76, align: right"]149:00[/TD]
[/TR]
[TR]
[TD="class: xl66"]Ben[/TD]
[TD="class: xl67"]02A[/TD]
[TD="class: xl74, align: right"]18:00[/TD]
[TD="class: xl75, align: right"]23:00[/TD]
[TD="class: xl75, align: right"]17:00[/TD]
[TD="class: xl75, align: right"]23:00[/TD]
[TD="class: xl75, align: right"]22:00[/TD]
[TD="class: xl75, align: right"]17:00[/TD]
[TD="class: xl75, align: right"]23:00[/TD]
[TD="class: xl75, align: right"]17:00[/TD]
[TD="class: xl76, align: right"]160:00[/TD]
[/TR]
[TR]
[TD="class: xl66"]Denize[/TD]
[TD="class: xl67"]03A[/TD]
[TD="class: xl74, align: right"]15:00[/TD]
[TD="class: xl75, align: right"]20:00[/TD]
[TD="class: xl75, align: right"]19:00[/TD]
[TD="class: xl75, align: right"]20:00[/TD]
[TD="class: xl75, align: right"]8:00[/TD]
[TD="class: xl75, align: right"]19:00[/TD]
[TD="class: xl75, align: right"]20:00[/TD]
[TD="class: xl75, align: right"]19:00[/TD]
[TD="class: xl76, align: right"]140:00[/TD]
[/TR]
[TR]
[TD="class: xl66"]Alex[/TD]
[TD="class: xl68"]04A[/TD]
[TD="class: xl74, align: right"]21:00[/TD]
[TD="class: xl75, align: right"]22:00[/TD]
[TD="class: xl75, align: right"]15:00[/TD]
[TD="class: xl75, align: right"]22:00[/TD]
[TD="class: xl75, align: right"]19:00[/TD]
[TD="class: xl75, align: right"]15:00[/TD]
[TD="class: xl75, align: right"]22:00[/TD]
[TD="class: xl75, align: right"]15:00[/TD]
[TD="class: xl76, align: right"]151:00[/TD]
[/TR]
</tbody>[/TABLE]
How can I sort data alphabetically by student names so that monthly and total hours don't get messed up?
Thanks!